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 →

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.

Outlook will flag your most important emails

Your inbox is about to get a powerful new ally. Find out how Outlook’s latest feature could help you cut through the noise of junk and spot the emails that really matter (and save time too)…

Don’t trust AI with this security essential

Are the passwords protecting your business as strong as you think they are?
There’s a growing shortcut that looks clever on the surface, and feels efficient, but could weaken your security without you realizing.
If you’re using AI in your business, this is something you need to understand…

Tech Tip: How to use Search Outlook Folders to organise your Inbox

Welcome to a new Tuesday Two Minute Tech Tip that will help you to organise your inbox using the Outlook powerful search features. Are you the kind of person who likes to organise emails into folders? Are you manually dragging your emails around to organise them? This...

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

Security Awareness Training Thumbnail Image

Human Error: The Achilles’ Heel of Your Cybersecurity

Small and medium-sized businesses (SMBs) are prime targets for cyberattacks, and the most vulnerable element in their defence is their workforce. Effective cybersecurity awareness training is essential for every employee across your organisation. But to implement it...

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

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

New: Windows 11 AI Agent helps with Settings

Ever get lost in your computer’s Settings, just trying to tweak one little thing? There’s a smarter way coming that makes finding and changing settings faster, simpler, and far less frustrating. Find out how it helps to save time, keep things private, and get your team get back to work quickly…

A woman on a laptop with a shield and lock on the screen

Why you should use a password manager

Introduction It can be difficult to keep track of all of your online passwords, especially if you have multiple accounts for different purposes. But did you know that there is a way to keep all of your passwords safe and secure? A password manager such as LastPass...

More Content