How to create a named range

Abstract

Named ranges are one of the most useful features in Excel.

Let’s take a look at a few ways to create named ranges.

Simply choose the cells you want to name, and throw in the name in the box.

Now I can easily refer to that name in a formula.

I’ll follow the same process with the Price column.

Now I can refer to the prices in other formulas by using that name.

For example, I can name the Beds column by first selecting the data and then clicking Define name.

Second, if you click into the reference, Excel will show you the range on the worksheet.

Excel can also name multiple ranges at the same time using the Create from Selection button.

To illustrate, I’ll create names for the data that appears in the summary table.

First choose the data and the labels, then click Create Names from Selection.

In this case, we need to tell Excel to use values in the left column for the names.

When I click OK, Excel creates three names.

Note that all names that are available to a worksheet will appear in the name box.

The Name Manager allows you to update and delete named ranges.

you might also confirm the cell references that each name defines.