How to create multiple names from selection in Excel?

If you have a range of data which contains multiple columns and rows, now, you need to create multiple range names based on these column and row labels. Normally, most of us may create the names one by one, however, if you are familiar with Excel's Create from Selection feature, you can create the names by the row and column headers at once.

Create multiple names from selection with Create from Selection feature

Create multiple names from selection with Create from Selection feature

Supposing you have the following data range, and now you can create range names based on the left column labels and top row labels with following steps:

1. Select the data range from top left to bottom right that you want to create names, A1:G7 in this example.

2. And then click Formulas > Create from Selection, see screenshot:

3. And in the Create Names from Selection dialog box, check the labels you want to create names based on. In this example, the labels are in the top row and left column of the selected cells, see screenshot:

4. Then click OK button to close the dialog, and the names have been created at once. You can go to the Name Box (next to the formula bar) to check the names.

Note: If the labels contain spaces or other invalid characters, such as & or #, they will be replaced with an underline.

Related articles:

How to create dynamic named range in Excel?

How to list named ranges in Excel?