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 →

6 ways to make your small business look professional

When you start out in business, one of the hardest things to do is find new clients. Most customers will not buy from you unless they trust you, and trust usually comes from reputation. But how do you gain people's trust if you are new and don't have much of a...

Tech Tip: How to use browser profiles

This Tech Tip is on how to use web browser profiles. If you are a freelancer, virtual assistant, or just wear many hats in your job role, you probably have multiple different logins for the same application. As so many applications are web-based, we have to login to...

Beware that “support call” – it could be a ransomware scam

Would your employees give an unknown caller access to your business devices? But what if they got a Teams chat from someone posing as Microsoft support? Here we tell you all about a new ransomware scam

Microsoft’s fixing the biggest issues in Windows 11

Ever feel like Windows 11 is getting in the way?
Or not as smooth as it should be?
Small frustrations eat up more time than you might think.
But Microsoft’s bringing in a shift that focuses less on new features and more on fixing those everyday frustrations…

Tech Tip: How to use Format Painter in Office 365

Welcome to a new Tuesday tech tip video where we will show you how to use a feature of Office applications called Format Painter. If you want to know how to quickly make the content of your Office documents look consistent, then this video will show you how. Format...

SharePoint made simple: How to supercharge your business

Still juggling files across laptops, Dropbox, and endless email chains? That chaos is costing you time, money, and sanity. Our latest guide shows you how to swap the mess for one secure, central hub where your team can collaborate seamlessly. Without stress or...

What’s your business’s view on Return to Office?

Do you love keeping your employees happy by allowing them to work remotely? Or do you think everyone is more productive in the office? Businesses are divided on this right now… here are some important considerations before you decide what’s best for your team.