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 →

Teams update: No more accidental quitting

Ever noticed how it’s the tiny software quirks that cause the most frustration?
If you live in Microsoft Teams meetings, there’s a subtle change rolling out that could make things feel noticeably smoother.
It’s one of those updates everyone will appreciate…

Is Wi-Fi 7 worth the investment?

Is upgrading to Wi-Fi 7 the right investment for your business? We look at the pros and cons of the next-gen wireless connection.

Spam emails are losing your business hundreds of hours every year

Spam emails: Very annoying and everyone hates them! They take up your time and make it hard for you to get other work done! A recent study found that each one of our employees could be losing 80 hours per year due the hassle associated with managing spam. That’s a LOT...

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.

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

Ransomware Attacks Grow for Small Businesses

Two organisations have recently released reports on the state of ransomware and cybersecurity incidents affecting small businesses. Datto's State of the Channel Ransomware Report Datto has recently released their "State of the Channel Ransomware Report" for 2019...

Donated Laptops for Lockdown Learning

A Digital Divide It is a shocking fact that 9% of children in the UK, between 1.1 and 1.8 million, do not have a computer, laptop or mobile device in their home, according to research carried out by Ofcom. This pandemic is shining a stark light on the gap in provision...

A woman looking at her phone while working from home

Homeworking is bad for IT security

A new homeworking security report from CyberArk has surveyed 3000 remote office workers and IT professionals. It finds that increased homeworking, resulting from the 2020 pandemic, could be bad news for a company’s IT security posture. It has uncovered several...

Are you ready for next-gen email security? (YES!)

Sick of spam emails? We have details of a cool new tool to help keep us better protected.

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.

More Content