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 →

Is app overload slowing down your team?

How many different apps and chat services are your employees juggling every day? Chances are, it’s making your business less productive. Good news: There’s a simple solution. We have the details.

A woman looking at her phone while working from home

Office 365 and Windows RDS: Maximum Remote Working Flexibility

Windows Remote Desktop Services (RDS) has been around for years. I was using it over 20 years ago and was a fan. It was an excellent solution for flexible working over slow connections, which is all we had back then! However, back then, you needed something else to...

How to get the most from Microsoft Teams

Is your business struggling with too many emails, lost files, and “final_final_v3” documents? Teams could be a game changer. Yep, it does more than just video calls. For example, you can also: Chat with your employees Host webinars Share and edit files together Keep...

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

Phishing – If you’re under pressure to take urgent action – stop and think

Phishing scams are one of the biggest security threats to your business right now and cybercriminals are always coming up with new phishing techniques. A massive 83% of organisations said they suffered successful attacks last year. And with just under a third of...

Let’s start talking about Artificial Intelligence (AI)

From Alexa to Siri, AI is already all around us, but names like ChatGPT, Dall-E and Jasper have blown up the internet. Let’s decode some of the language

Beware the next generation of phishing attacks

Most phishing scams still feel a little… amateur.
But the next shift is dangerous.
Attackers are changing how scams are built, not just how they’re sent. And the signs people have been trained to look for won’t always be there anymore…

What to do when disaster strikes: Creating an Incident Response Plan

Your business has firewalls, the latest security software, multi-factor authentication, and, of course, uncrackable passwords. You may even have Cyber Essentials—high five. But… It’s still not enough to protect you from 100% of cyber attacks. Completely watertight...

Microsoft: Criminals can access your accounts without your password

Just when you think you’ve got cyber security sorted for your business, a new scam comes along. This time, cyber criminals don’t even need to trick you out of your password to access your accounts… they can fool you with something called a “device code”.

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.

More Content