Creating named ranges

This section provides different ways to create named ranges in spreadsheets.

To define a name for a cell range, do the following steps:

1. Select the cell range and click Insert > Names > Define to open the Define Names window.
2. Enter the name for the range in the Name field.
   
3. Click OK to close the window.

To automatically define names for rows or columns in a cell range, do the following steps:

1. Select the cell range and click Insert > Names > Create to open the Create Names window.
   
2. Select the options in the Create names from field. For example, if you select the Top row option, each column without the top row is defined as a range, and the text in the top row is used as the name of this range automatically.
3. Click OK to close the window.

To define a cell reference for a label range, do the following steps:

1. Click Insert > Names > Labels to open the Define Label Range window.
2. Click the editing area in the Range field, and then select a cell range as the reference. The label range is set by default. For example, if you select a certain row in your spreadsheet, all the columns under this row are defined as a label range by default.
3. To change the label range, click the For data range field and select a new label range.
4. Click OK to close the window.