How to Make Named Ranges in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on how to make Named Ranges in Excel.

So, what is a Named Range in Excel???

A Named Range is a feature in Excel that lets you assign a name to a range of cells that you select on your spreadsheet. You can then access and reference these cells by using the new name, rather than repeatedly typing cell numbers or reselecting the same area.

Creating Named Ranges in Excel can help you save time in several ways – like letting you quickly jump to the named range, typing your named range in formulas instead of looking for and selecting cells, and creating hyperlinks in your spreadsheet to the Named Range.

In this Named Ranges tutorial, we go over how to name your Named Range, ways to create Named Ranges and then examples of how you can use Named Ranges in your spreadsheets to save time.