Skip to content Skip to bottom

How to Create Named Ranges in Microsoft Excel

Microsoft Tips

Named ranges in Excel are useful for providing simple navigation across your workbook. If you work with Excel spreadsheets a lot, then organising your worksheets with named ranges will save you a lot of time. Instead of using the cell reference (e.g., A1, B1 etc..) you can simply use the name that you assigned to it.

In this video you will learn how to create named ranges in Excel and how to use this method to save you time.

If you would like to learn more about other features and functionality within Microsoft Excel, then head over to our YouTube. We have a channel of videos called Microsoft Excel for beginners, here you will find lots of quick intuitive tutorials to help you master Excel. All of our videos are delivered by a Microsoft Certified expert.

Using Named Ranges in Excel

In Microsoft Excel, you can create range names that refer to:

  • Cell(s) on your worksheet
  • Specific word or number values
  • Formulas

Once you have defined your Excel range names, you can:

  • Utilise the names in a formula, instead of using cell references or a constant value.
  • Search a name and quickly go straight to that named range of cells.
  • Use the range names as a source for the items in a data validation drop down list.

Learn more about Microsoft Excel from a Microsoft Certified expert

The 848 Group is a Microsoft Gold Partner with a team of Microsoft Certified professionals. Amongst our team of highly skilled staff, we have training specialists who are experts in all things Office 365. From Word, PowerPoint, and Excel to Outlook and Microsoft Teams, our training specialists know it all.

We have a range of Microsoft 365 training courses designed to meet varying end user capabilities. As well as many other videos to help you improve your Microsoft Excel skills.

Choose from a range of introductory courses that help you learn the essentials, or level up your Microsoft skills with an advanced course. Course timelines are flexible, with bitesize classes to full day sessions available.

Find out more about our training courses here!