Tech Tip: How to name cells in Excel

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 →

What’s coming in Windows 11?

Microsoft has just announced (in a typically 'West Coast' way) what's coming in Windows 11. Here is a rundown of what was announced at the event. Windows 11 Interface Design The first impression visually is that it looks kind of like Linux merged with Mac OSx. The...

Are your younger employees experiencing ‘tech shame’?

Gen Z and even some Millennial employees are less tech savvy than many employers might expect. It’s an assumption that’s leading to a sense of ‘tech shame’.

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...

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.

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

The little things that make a big difference

Microsoft’s made another update to Windows 11, and while it’s a small one, it could make a big impact. We have all the details of what’s changing.

Getting to Grips with Email Security

Owners of small and medium-sized businesses often make the mistake of thinking that they aren’t on the criminals’ radar. But more than 40% of cyber attacks are aimed at small businesses – and email is usually the criminals’ way in. Our new guide, ‘Getting to Grips...