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 →

Never lose a Word document again

You know that sick feeling you get when your computer crashes?
Hours of work swirl down the drain. All because you forgot to hit “Save”.
Well, Microsoft’s got an update that means that will never happen again…

A third of all data loss is caused by problems with backups

The lack of a reliable backup causes a third of all data loss

Your business data is backed up and recovery tools are in place. So, your data is safe, right? Sadly… not always. Here’s why we recommend backups are checked regularly..

Save time by accessing your Android phone’s files with File Explorer

A new feature in Windows 11 may make accessing files on your Android phone much quicker. We have all the details.

Don’t think your business is a target? Think again

Cyber criminals are targeting businesses of all sizes, all the time. And new research shows just how they’re doing it. We tell you how to stay protected.

At last: Sync passkeys across your devices

Tired of juggling passwords and endless reset emails?
There’s a smarter, safer way to log in. Once again, Microsoft is about to make life a lot easier for you and your team.
No passwords. No lockouts. Just quick, secure access wherever you are…

The Grim Reaper hacker attacking businesses without Cyber Essentials

Cyber Essentials: Why Doing the Basics Well Still Protects Most SMEs

If you read the headlines, cyber security can feel like a losing battle. Ransomware, phishing scams, data breaches, every week brings a new story, and every story seems to end the same way: another business in trouble, another customer base shaken, another bill no one...

7 Cybersecurity Threats That Could Wipe Out Your Business

Cyberattacks aren’t rare anymore—they’re routine, and cybersecurity for small businesses has never been more important. Whether you’re a small business or a growing enterprise, the threats are real, relentless, and evolving faster than traditional defences can keep...

Getting Started With Microsoft Teams

Microsoft Teams is a powerful collaboration tool and is included with all business versions of Microsoft 365. If you have Microsoft 365, and are not using Teams, or you don't yet have Microsoft 365 and want to know what Teams can do, this video is a quick...

Blisstech Solutions sponsors KEMP’s Virtual Santa Fun Run

In 2020 everything has been different, and the traditional KEMP Hospice Santa Fun Run is no exception. In a year where so many charity and participation events have been cancelled, it is great to see that this iconic local event is going ahead, albeit in a very...

Microsoft: Criminals can access your accounts without your password

Just when you think you’ve got cyber security sorted for your business, a new scam comes along. This time, cyber criminals don’t even need to trick you out of your password to access your accounts… they can fool you with something called a “device code”.

More Content