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 →

How Much Should You Pay for IT Managed Services in the UK?

This article has been updated to reflect the market in 2026. If you are looking for managed IT services in the UK, you should understand that there is no "one-size-fits-all" solution. There are many managed service providers out there, and they offer a huge range of...

And the award for most common phishing scam goes to…

Which phishing scam are you and your employees most at risk from? We tell you about the most common phishing emails and the easy way to stay safe.

Microsoft Edge introduces a new scam protection tool

Those fake “your computer is infected” pop-ups are getting smarter. And scarier.
But there’s some big news from Microsoft that could make them a thing of the past.
This update to Edge is changing how your browser fights back against online scams…

Passkeys will be better integrated in Windows

Big changes are coming to Windows 11 to make logging in safer and easier. Which is why now’s the time to get ready for a password-free future…

Another good reason to enforce MFA

What if a password your team hasn’t used in years could still open the door to your business?
No hacking drama. No clever tricks. Just old login details quietly doing damage.
This is exactly how a recent cyber incident caught businesses out. It’s a threat many business owners don’t see coming…

This new search feature in Edge is a revolution

Microsoft’s Edge browser has an amazing new search feature that we think is a total game changer, and the most compelling reason yet to switch. We have all the details.

Is this the most dangerous phishing scam yet?

Is SubdoMailing the most dangerous phishing scam yet?

Bad news: Cyber criminals have yet another new phishing scam up their sleeves and it could be the most dangerous one yet. They’re using genuine subdomains that have been abandoned. We tell you how to stay safe.

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.

Cyber attacks are getting bigger and smarter. Are you vulnerable?

Recently, the biggest ever DDoS attack was reportedly blocked. Worse still, more businesses are being targeted with criminals demanding huge ransoms

8 tech trends you need to prepare for in 2023

The end of the year is a time when many business owners take time to reflect and plan for the coming year. For many that will involve thinking about forecasting and growth over the next 12 months, but we want you to think about the tech trends in 2023 that will affect...

More Content