Name Ranges using “Create from Selection”

Named ranges can be used to make it easier to navigate large worksheets but can also be used in formulas instead of typing or pointing to specific cells.
In this example we will demonstrate how to quickly name a range or name multiple ranges at once using “Create from selection”

Name A Single Range

To name a single range:
In this example we are going to name the range B1:B10

Naming Cells or Ranges1

1. Select the range of cells you want to name.

2. Click the FORMULAS tab.

3. In the Defined Names group click Create from Selection.

4. The Create Names from Selection options box will open.
Check the box where the name for the range is located.
In this example the name is in the Top row of the selected range.
Click OK in the options box.

The range B1:B10 is now named January.

Naming Cells or Ranges2

You can check this by clicking the Name Manager command located in the Defined Names group.
The name manager shows the range name January refers to the range B1:B10.
By default excel will make the range reference absolute.

Name Multiple Ranges

You can name multiple ranges at once using the same method as above.
In this example we want to name each column that has a month in the header and also each row that has a car manufacturer in column A.

We can do all this at once by:

Naming Cells or Ranges3

1. Selecting the entire range of cells you want to name.

2. Click the FORMULAS tab.

3. In the Defined Names group click Create from Selection.

4. The Create Names from Selection options box will open.
Check the box where the name for the range is located.
In this example the name is in the Top row of the selected range and also the left column.
Click OK in the options box.

Select the Name Manager and you will that all the ranges have now been named.
Naming Cells or Ranges4