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 →

Gadget overload? How many devices do you use at work?

Are all the devices your team uses helping them stay productive – or hindering them? Every extra gadget means another thing to remember, charge, and carry. There’s a simple way to help streamline tech in your business…

Charging in public places? Watch out for “juice jacking”

Airports, hotels, cafés, even shopping centres, offer public charging points where you can boost your phone or laptop battery on the go. They’ve been in the news after the FBI recently tweeted advice to stop using them. Crooks have figured out how to hijack USB ports to install malware and monitoring software onto devices as they charge. The security risk …
Read More

Zoom wants to be the new Teams

Zoom is looking for a piece of the MS Teams action with the launch of a whole suite of features and services

Windows 11 uptake is at an all-time high – what are you waiting for?

If you’re still attached to Windows 10, now’s the right time to upgrade. Here’s why…

Ransomware threats are surging – here’s how to protect your business

After years of decline, ransomware attacks are on the rise again. And more businesses are being targeted. It’s time to protect your data. Here we explain how.

Why is my computer so slow!?

“Why is my computer so slow?” is a question heard time and time again and is one of the most common computer complaints. There are a variety of reasons that your computer can appear to be running slowly. I say ‘appear’ as it may not actually be your computer that is causing the problem. Read on to find out possible reasons for this problem.

New: Windows 11 AI Agent helps with Settings

Ever get lost in your computer’s Settings, just trying to tweak one little thing? There’s a smarter way coming that makes finding and changing settings faster, simpler, and far less frustrating. Find out how it helps to save time, keep things private, and get your team get back to work quickly…

Tech Tip: How to use Windows Clipboard History

Welcome to a new Tuesday tech tip video where I will show you a really cool Windows feature called Clipboard History. Do you ever find yourself copying and pasting the same text or images over and over again? If so, you're not alone. But there's a better way! Windows...

Secure your data under lock and key

Your business's data is invaluable. Without it, you wouldn’t have much of a business, would you? So that data must be kept safe… and one of the best ways to do that is to encrypt it. That way, even if a cybercriminal gets their hands on it, your data is worthless to...

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.

More Content