How to Paste Range Names in Excel

This tutorial will demonstrate how to paste range names in Excel.

 

 

If you have a workbook that contains a lot of named ranges, you can use those range names in alternative locations or formulas in your Excel file.

Pasting a Range Name to Another Location

1. First, select the cell where you wish the range name to be pasted.
2. In the Ribbon, select Formulas > Defined Names > Use in Formula > Paste Names…

 

 

3. Select the name you want to paste, then click OK.

 

 

4. Press the ENTER key on the keyboard or click the check mark in the formula bar.

 

 

The range name will be inserted as a Dynamic Array. You cannot edit individual cells in a dynamic array or delete the values in the cells underneath your formula (for example the values in C3 and C4 in the example below): The cells, together, form part of an individual range name.

 

 

Pasting a Range Name into a Formula

You can also paste range names into formulas.

1. First, type the beginning of the formula. (This example uses the SUM Function.)
2. In the Ribbon, go to Formulas > Defined Names > Use in Formula > Paste Names… Then select the name required and click OK.

 

 

3. Press ENTER for Excel to automatically complete the formula with a closing parenthesis.

 

 

Use in Formula List

An alternative (and simpler!) way to paste a range name into a formula is to directly select the name from the Use in Formula list.

1. Type the first part of the formula.
2. In the Ribbon, go to Formulas > Defined Names > Use in Formula, then select the name you require.

 

 

3. Press ENTER for Excel to automatically complete the formula with a closing parenthesis.