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 →

Tech Tip: How to add a FROM address in Outlook NEW

Welcome to a new Tuesday tech tip video. In it, I will show you how to add a FROM address (or alias) in the new version of Outlook. Microsoft's new version of Outlook, imaginatively titled Outlook New, is very different in look and feel from the Outlook we've all...

The secrets to make your laptop battery live longer

Ever been caught out by a low laptop battery at the worst possible time? Here’s our professional advice to prolong your laptop battery’s lifespan.

Protect your business from a data leak with Microsoft Edge

Keeping your data away from the wrong hands is a big challenge. But thanks to Microsoft Edge for Business, it’s just become easier. Here we tell you why.

Cloud Telephony vs. VoIP – which is best for your business?

If your employees—or worse, your customers—have started to complain about your phone systems, it’s time to look at a new solution—something that works well for everyone, whether that’s making life easier for your team or giving your customers a smoother experience....

Important: Protect your business from digital fraud

Digital fraud isn’t on the rise. It’s evolving. Fast.
Scammers are using smarter tools, more convincing messages and pressure tactics designed to make even careful people slip up.
These are the simple habits that could stop your team from falling for them…

Is your business data at risk? Don’t take chances with old tech

Old computers and external drives can put your sensitive business data at risk.
We look at how to dispose of old computers and external drives in the safest way possible.

Beware fake apps containing malware

How do you know the app you just downloaded is really what it claims to be? Even your most careful employees may be fooled. Is your business ready for that risk?

Serious Flaws Discovered in D-Link Routers

Researchers at Fortinet have uncovered serious flaws in four D-Link routers. The router vulnerabilities were found to allow for remote code execution which means a remote attacker could gain control of your router, snoop on your traffic and redirect your browser to...

Copilot could soon auto-open in Microsoft Edge

Is Edge your business’s browser of choice? Microsoft’s thinking of automatically opening Copilot when you use it. It could boost productivity, but there are privacy concerns to be aware of…

Searching in Windows 11 is about to get easier… for some

Searching for files in Windows isn’t always a smooth experience. Sometimes it’s slow and often it’ll show you web results rather than the file you need. But Microsoft is making things much simpler… for some people. Here’s how you can benefit from this.

More Content