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 →

And the award for most common phishing scam goes to…

Which phishing scam are you and your employees most at risk from? We tell you about the most common phishing emails and the easy way to stay safe.

Tech Tip: Quickly add lines numbers and bullets in Word

Happy Tuesday everyone! Today's Tech Tip is a tip on how to use some of the formatting shortcuts in Word to add lines, bullets and numbers to organise your documents. If you use Word to write your documents, and 90% of people do, you will love this tip as it will show...

Can’t find what you need in Teams? This makeover will increase your business’s productivity

The Teams Fall 2024 update will increase your business’s productivity

The latest feature update in Teams is bringing a central notifications hub to keep things more organised. And a whole host of other useful features. We’ll tell you all about it here.

Another good reason to enforce MFA

What if a password your team hasn’t used in years could still open the door to your business?
No hacking drama. No clever tricks. Just old login details quietly doing damage.
This is exactly how a recent cyber incident caught businesses out. It’s a threat many business owners don’t see coming…

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…

Tech Tip: How to use Pivot Tables in Excel

Welcome to Tuesday's Two Minute Tech Tip where Matt shows you how you can explore your Excel data using the power of Pivot Tables. Pivot Tables are a powerful feature of Excel that allows you to manipulate your flat Excel data to perform calculations and create charts...