Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

 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, but, if you are familiar with Excel, with its 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


arrow blue right bubble 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:

doc-create-names-from-selection-1

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:

doc-create-names-from-selection-2

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:

doc-create-names-from-selection-3

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.

doc-create-names-from-selection-4

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?



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Mimi · 3 years ago
    I love the 'create names from selection command' but I cannot get around this limitation. When I create names it assigns the scope to the workbook and I cannot edit it afterwards.

    I had to get around this by creating a dummy sheet and creating the names there. Then I copy the cells to the sheet that I want it assigned to and create names there; now it assigns the scope to the worksheet I wanted. Then I go back to the name manager and delete the dummy names.

    I hope there is a better way. Someone else must have wanted to do this.

    Thanks.