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 →

Is that Chrome extension filled with malware?

Chrome extensions are great for boosting productivity and saving time. But if they’re not the real deal, you could be at risk from malware. We tell you how to stay protected.

Tech Tip: Understanding Microsoft work and personal accounts

Welcome to another Blisstech Solutions Tuesday Tech Tip! Have you set up both a personal and work Microsoft account and are now running into problems when you are trying to work as you can't work out which account you are logged in with? You are not alone and we see...

Outdated backup systems could leave your business vulnerable

When did you last review your business’s backup tools? Outdated backup systems can fail to protect you from modern threats, like ransomware attacks. If you want a reliable backup system, here’s what you need to 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...

Why the Cloud is not backup

Cloud computing has revolutionised the way businesses work. Companies that utilise the cloud will have coped the best with COVID-19 imposed restrictions. Whether forced to by circumstance or not, businesses are moving from the traditional server in the office to...

Tech Tip: How to check if your device is compatible with Windows 11

Welcome to a new Tuesday tech tip video. In it, I will show you how to check if your device is compatible with Windows 11. With Microsoft's termination of support for Windows 10 in October 2025, it's crucial for business leaders to proactively plan for the transition...

Security alert: Attacks on business email accounts are surging

Security alert: Business Email Compromise attacks are surging

Your business relies on emails every day – that’s exactly why scammers target them. Here’s what you need to know.

Searching in Windows 11 is about to get easier… for some

Searching for files in Windows isn’t always a smooth experience. Sometimes it’s slow and often it’ll show you web results rather than the file you need. But Microsoft is making things much simpler… for some people. Here’s how you can benefit from this.

How to disable fast startup - thumbnail image

Tech Tip: How to disable Fast Startup and shutdown your computer properly

It is a fact of life that we occasionally have to turn our Windows computers off and back on again to fix problems. However, if you are not shutting down your computer fully then your efforts may not have the desired effect because of a feature called Fast Startup....

Why you will not be fine on this Cloud9

Fake Flash messages are being used as a cover for a new ‘botnet’ campaign. If you use Google Chrome or Microsoft Edge you could be a target.

More Content