Create from Selection

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

  1. Enter data in the worksheet as below.

  2. Select the B1:D5 area and click Formula-Name-Create from Selection.
  3. In the Create from Selection dialog box, select First Row and click OK.
  4. 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.

See Also