This feature allows you to define a name for the selection with the data in the selection. You can define a new name without typing a name.
Steps
To define a name in the selection
- Enter data in the worksheet as below.
- Select the B1:D5 area and click Formula-Name-Create from Selection.
- In the Create from Selection dialog box, select First Row and click OK.
- The content of the cell in the first row of each column is defined as the name of the rest of the cells in each column.
More Information
Create from Selection Dialog Box
First Row
The data in the first row of the selection is defined as the name of the other areas. If multiple cells are selected, the data in the first row of each column will be defined as the name of the other areas.
Last Row
The data in the last row of the selection is defined as the name of the other areas.
Left Column
The data in the left column of the selection is defined as the name of the other areas.
Right Column
The data in the right column of the selection is defined as the name of the other areas.
Notes
Area defined by name
If you select multiple cells and then choose First Row in Create from Selection, the first row in each column is defined as the names of the remaining area in the same column.
Duplicated area
If you select multiple cells and then select First Row and Left Column in Create from Selection, the data in the cell where the first row and the left column intersect is defined as the name of the entire area.
Syntax rules for names
The name must start with a letter, underscore, or backslash, and the name cannot contain spaces or other symbolic characters. Names that do not match the syntax rules are skipped, and names that match the syntax rules start with the next name.