Tech Tip: How to name cells in Excel

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 →

Beware: Is that Microsoft… or a phishing attempt?

Another email from Microsoft. But this time it’s asking you to take urgent action to protect your account. Before you click any links or provide any personal information, ask yourself: Is it really Microsoft? Or could it be a phishing attempt? Here’s how to tell…

Which ransomware payment option is best? (Hint: none)

Cyber criminals are giving you more options when it comes to paying your way out of a ransomware attack. Our advice remains the same though. Find out what that advice is here.

Don’t forget to protect your browsing privacy

Your mobile browser knows a lot more about you than you think.
Not just the sites you visit, but patterns, habits, clues about your business.
Most people never check what’s being shared or stored behind the scenes.
It’s time you take a look…

Windows 12 is coming… here’s what we know so far

While Windows 11 is only just celebrating its first birthday, we’re already hearing our first rumours about what Windows 12 will have in store. There’s no rush for the time being – we won’t see this new operating system until the back end of 2024 – but we love to be ready for what’s coming next, so here’s what we know …

Outsourcing always beats DIY

Do you ever feel like you're juggling ten tasks at once to keep your business running? Marketing, sales, finances, IT… the list goes on! And somewhere in that chaos, your dreams for growth get lost. Enter Dave, a fellow entrepreneur who has created the same...

Stop AI agents creating security blind spots

AI is starting to do more than just help your team.
It’s making decisions and taking actions on your behalf.
Everything runs and work gets done faster. 
But if something doesn’t look right, could you explain why?

How to spot a scam

Would you know how to recognise a scam? In the 21st century, you are highly unlikely to encounter a con artist in the street as they hide behind phones, text messages and emails. But the motivations behind 21st-century fraudsters have not changed; they want to make...