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 →

Be more productive with these Microsoft Edge features

In the never-ending mission to be more productive, the latest Microsoft Edge browser could be a powerful ally. We’re telling you about 5 of its best productivity features.

Young employees have different attitudes to cyber crime

If you employ anyone aged between 16 and 19, you need to pay special attention to the cyber security training you’re giving your team.

Your business’s passwords are still too weak

“iloveyou”, “12345”, “qwerty1”. If I’ve just guessed all your passwords, you need to change them, immediately. Why? Because your passwords are STILL too weak. It’s a big problem…

IT Managed Services for HR and Recruitment

Technology has significantly impacted businesses involved with human resources, changing how HR and recruitment organisations and professionals operate. Technology has automated many administrative tasks, has made it easier for HR and recruitment professionals to...

Better battery life for Windows 11 laptops

Wish your laptop could last longer on a single charge? Big changes could be on the way that help your team work smarter (and stress less about finding outlets).
Learn more about this business-boosting improvement from Microsoft and Windows 11…

PowerPoint drops its “Reuse Slides” feature

Have you noticed a time saving feature is missing from PowerPoint?
It’s not a mistake. But it might be a productivity killer.
Luckily, there are a couple of workarounds. Your people need to know about these…

Beware fake apps containing malware

How do you know the app you just downloaded is really what it claims to be? Even your most careful employees may be fooled. Is your business ready for that risk?

Microsoft’s browser takes back the Edge with streamlined settings

Microsoft’s browser takes the Edge with streamlined settings

Trying to find your way through the Settings menu in Microsoft Edge might leave you overwhelmed but a new update is about to make it easier. Here we tell you how.

Tech Tip: How to use Microsoft Teams as a phone system

Welcome to a new Tuesday tech tip video. In it, I will demo the Microsoft Teams Phone system. Microsoft Teams has become a cornerstone for collaboration, offering seamless chat and meeting experiences for millions of users worldwide. But did you know that Teams can...

Is Your Business Ready for Coronavirus Lockdown?

With the COVID-19 coronavirus continuing to spread in the UK, and Italy and China placing lockdowns on their towns and cities, it seems likely that the UK will follow suit if the outbreak continues apace. Experts have stated today that the spread of the virus in the...

More Content