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.

More Content

Your need-to-know guide to cloud security

Cloud computing is no longer new technology, it is everywhere and has completely changed how we work. However, just because you are using someone else systems in the cloud, it does not imply that it is automatically secure. There is a saying in the cloud security...

How to Plan for Upgrading to Windows 11: A Guide

The Clock’s Ticking for Windows 10: Are You Ready? 14th October 2025 is the day Microsoft ends free support for Windows 10. This means no new features, no bug fixes, and no more security updates. You can't risk that. Why Upgrade to Windows 11? Windows 11 offers a...

Bring Your Own Device: Dos and don’ts for your business

Do you let employees use their own phones, laptops, or tablets for work? That includes things like sending a quick email or updating a client account. If you do, it’s important to remember that personal devices often lack the security measures of work-issued devices....
Slow PCs? Manage which applications launch at startup

Slow PCs? Manage which applications launch at startup

Your PC might be frustratingly slow because too many applications are starting up when you hit the power button. Windows 11 has a new solution to tell you when new apps are added to your startup list. We have all the details.

Why all businesses should adopt MFA now

Years ago, Multi-Factor Authentication (MFA) used to be called 2FA, or Two Factor Authentication.  This was made up of: Something you have, like a device that can generate a one-time password (OTP). Something you know, like a password. MFA has extended things meaning...
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....

Don’t forget your phone when you think about cyber security

Our phones are a goldmine of private information. If they’re not as secure your other devices, they can become a gaping hole in your cyber security

You’re not imagining it, video calls ARE stressful

You’re not imagining it, video calls ARE stressful

Video calls stressing you out? You’re not alone. Scientists have warned about the negative effects of too much camera time. We have the solution for your team.

How Copilot Wave 2 can boost your business

Imagine how different your business would be without Microsoft 365’s suite of apps and tools. It’s a business essential that makes everything easier. Now imagine these apps and tools could do more. Imagine they could summarise reports, documents, and meetings. Or...

How to get the most from Microsoft Teams

Is your business struggling with too many emails, lost files, and “final_final_v3” documents? Teams could be a game changer. Yep, it does more than just video calls.  For example, you can also: Chat with your employees Host webinars Share and edit files together Keep...
Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

01299 382 321
[email protected]
Copyright © 2024 Blisstech Solution Ltd
Registered No: 08125391 VAT No : 307 5490 05