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 →

Back up your data! One day it could save your business

Did you know that 60% of companies that lose their data will shut down within six months of the disaster? Don’t let your business fall into this statistic.

How future proof is your business’s IT?

Your business’s tech might be working well today, but is it ready for tomorrow? A new study has found more than 60% of business leaders aren’t confident about theirs. What about yours?

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

Tech Tip: Understanding Microsoft work and personal accounts

Welcome to another Blisstech Solutions Tuesday Tech Tip! Have you set up both a personal and work Microsoft account and are now running into problems when you are trying to work as you can't work out which account you are logged in with? You are not alone and we see...

Microsoft takes the pain out of updates with checkpoint cumulative updates

Updates are a pain, right? Time consuming and disruptive. Not anymore… Here we tell you how Microsoft’s latest Windows 11 update is making things quicker and easier.

Businesses are taking too long to fix vulnerabilities

If you knew your systems were at risk of attack, you’d jump in and get things locked down fast – right? Actually… many businesses take too long to fix vulnerabilities. Here’s why that’s a problem.

Reverse image search makes purchasing and marketing easier

Bing Visual Search makes purchasing and marketing easier

Think the Windows 11 Photo app has little use in your business? Visual Search with Bing is about to change that, with some very useful new functionality… Find out more here.

Tech Tip: Master Your Multitasking – Switching Apps and Desktops Like a Pro

Welcome to a new Tuesday tech tip video where I will show you how to switch between applications and desktops in Windows quickly. Sick of losing track of what you're doing because you have too many windows open? Let's face it: we've all been there. Well, this video is...

Now Copilot’s going to make your team work better together

Microsoft isn’t happy just boosting individual productivity. Now it’s set its sights on helping your team work better together. We’ll tell you how.

Bridging the trust gap between your employees and AI

Have you noticed your employees are reluctant to use AI in the workplace? It may be down to their lack of trust. We explain how to show them AI is a tool that makes work better for everyone.

More Content