Tech Tip: How to name cells in Excel • Blisstech Solutions

Welcome to a new Tuesday tech tip video where I will show you how to name cells in Microsoft Excel.

Naming cells can make your spreadsheets easier to understand and maintain and help you write more concise and efficient formulas.

In the video, I show one way of doing this, but there are two ways to name cells:

Using the Name Box: This is the simplest way to name a cell. Simply select the cell you want to name, and then type the name in the Name Box at the left end of the formula bar.
Using the Define Name dialogue box: This method gives you more control over the name of the cell, and it also allows you to create named ranges. To open the Define Name dialogue box, click on the Formulas tab and then click the Define Name button in the Defined Names group.

I will also show you how to use named cells in formulas.

Named cells can be used just like cell references, so you can use them in any formula that you would typically use for a cell reference.

By the end of this video, you will know how to name cells in Microsoft Excel, and you will be able to use named cells in your formulas.

Check out the video to learn more and subscribe to our YouTube channel.

Thanks for watching.

← Windows 11 optional update: Why it’s better to wait The final curtain call for Windows 10: What you need to know →

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

Microsoft’s fixing this annoying Windows 11 fault

Fed up seeing useless “Recommendations” in the Windows 11 Start menu? Good news – Microsoft’s making them more helpful. Here’s how the improvements could help your team save time…

How a strategic IT advisor pays for themselves

Does your IT support service help your business grow? Or is it just fixing things when they break? If your current approach is all panic, invoices, and short-term fixes, it’s time for a rethink. A strategic IT advisor becomes a true partner in business growth, helping...

Now AI can make your Teams meetings more productive

Microsoft Teams Meeting Recap will summarise your meetings and even make a list of the action points. We show you its other benefits

How to help your people be AI confident

Has your business embraced AI? Or do employees feel worried or even judged for using it?

If you want to benefit from everything AI can offer, you need to give your team a confidence boost. Here’s how…

It’s time to govern your team’s AI use

Quick question: Do you know how your team is using AI at work?
Not how you think they’re using it, but how they’re really using it?
Most businesses don’t. And that’s where the risk creeps in…

Do I need Antivirus on a Mac?

Broadly speaking there are two different types of desktop computer users; Windows users and Mac users (sorry Linux users but you are very much in the minority). Microsoft has included a free antivirus solution called Windows Defender for years because they realised...

The BEST protection against ransomware

Ransomware attacks – where hackers steal your data and demand a ransom to give it back – are skyrocketing. You need to have the very best protection in place to keep your data secure. And here’s what that protection is…

Small habits to make your Windows 11 PC last longer

Ever written off a work PC because it felt slooooooow?
In a lot of cases, it’s not age doing the damage. It’s small, everyday habits slowing things down over time.
A few simple changes can make a surprising difference to how long business devices stay usable. And how often you replace them…

PING, WHOOSH, or BEEP? Now you can decide with Teams

Is the sound of yet another Teams notification about to drive you crazy? A new update will put a stop to that… and it’ll help you prioritize your tasks too. We have all the details here.

More Content