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
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?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, 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!