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 you using Teams to share sensitive data?

Microsoft Teams has fast become one of THE most useful business tools for the way we work today. No matter where your people work from, they can communicate and collaborate quickly and reliably. But this remote way of working can also open the door to some MAJOR security issues. New research shows that nearly HALF of employees frequently share confidential …

Don’t walk the plank with pirated software

A huge number of small and medium-sized businesses would consider using pirated software to try and save money. Don’t do it.

Is your team using AI well? Copilot can tell you

You’ve adopted Copilot in your business. You know the potential benefits are huge.

But is your team as enthusiastic about using it as you are?

This new feature will tell you…

What does the global chip shortage mean for your business?

For the past couple of years, the tech world has been struggling with a global chip shortage. But it’s not just tech businesses that are feeling the impact. So many of the things we use every day contain a chip. Laptops and desktops, sure. But also household...

Windows Hello gets a new look and improved security

Windows Hello gets improvments in security usability

Is your business using Windows Hello yet? It offers easier and more secure login methods – and it’s about to get an upgrade. Here’s what’s changing.

Tech Tip: How to Sync Teams Files to Your Computer

Hello everyone, welcome to a new Tuesday Two Minute Tech Tip. 👉 Do you use Microsoft 365? 👉 Do you need to collaborate on documents with your colleagues? 👉 Do you want to do this using the same familiar Windows...

That long password isn’t keeping you better protected

Even passwords of 15 characters can be cracked by cyber criminals. Our latest tech update explains what to do instead

How to stop AI projects stalling

If your business has experimented with AI but hasn’t seen much change, it’s a sign of something missing, not something broken.
The obstacles usually have nothing to do with the technology…

Microsoft finally fixes these Teams issues

Notice how tiny tech quirks can disrupt an otherwise productive day?
Some long-requested fixes are finally rolling out in Microsoft Teams.
The kind of changes that remove those everyday irritations you’ve probably stopped complaining about because “that’s just how it is”.
But not for much longer…

Don’t Overlook Home Worker Security

Protecting Home Workers and Your Business In the current work-from-home landscape, business security strategies often overlook one crucial aspect: home office security. This oversight creates vulnerabilities that cybercriminals are actively exploiting. With more...

More Content