Naming tables
You can name tables, floating cells, and table components, such as cells, a range of cells, rows, or columns. Naming a table or table component lets you reference it quickly. It is easier to remember a name, such as “Balance,” than to remember a cell address. A name can contain letters, numbers, spaces, and the symbols #, $, ?, @, or _; however, the first character must be a letter, number, or underscore (_). You can also use text in a cell to name a table or table component.
You can edit and delete the names of tables, floating cells, and table components, such as cells, a range of cells, rows, or columns.
To name a table |  |
|
1.
|
|
Select a table.
|
|
2.
|
|
Click Table
 Names. |
|
3.
|
|
Choose the default table name from the Table/floating cell list box.
|
|
4.
|
|
Click Edit.
|
|
5.
|
|
In the Edit table name dialog box, type a name in the Name box.
|
To name a table component | |
|
1.
|
|
Click a table component.
|
|
2.
|
|
Click Table
Names. |
|
3.
|
|
Click Create.
|
|
4.
|
|
In the Create table name dialog box, enable one of the following options:
|
|
•
|
Cell/range — specifies the cell or range in which the cursor is positioned
|
|
•
|
Row — specifies the row in which the cursor is positioned
|
|
•
|
Column — specifies the column in which the cursor is positioned
|
|
5.
|
|
Type a name in the Enter name box.
|
To name table components by using text in a cell | |
|
1.
|
|
Select a cell that contains the text you want to use.
|
|
2.
|
|
Click Table
Names. |
|
3.
|
|
Click Create.
|
|
4.
|
|
In the Create table name dialog box, enable the Use text in current cell to name option.
|
|
5.
|
|
Enable one of the following options:
|
|
•
|
Row — names the row in which the cursor is positioned
|
|
•
|
Column — names the column in which the cursor is positioned
|
|
•
|
Next cell to right — names the cell to the right of the cell in which the cursor is positioned
|
|
•
|
Next cell down — names the cell below the cell in which the cursor is positioned
|
To edit the name of a table component | |
|
1.
|
|
Select a table component, and click Table
Names. |
|
2.
|
|
Choose the name of the table component from the Cell, row, column, or range list box.
|
|
3.
|
|
Click Edit.
|
|
4.
|
|
In the Edit table name dialog box, type a new name in the Name box.
|
|
If you want to delete a name, click Delete.
|