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
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.
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel
2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features
30-day free trial. 60-day money back guarantee.
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.