-
Open the Formula Table window in one of the following ways:
- On the ribbon, from the group on the Data tab, click .
- In classic view, click Database menu > Formulas > Formula Tables.
- Click
, and then select the formula table you want to change. - Make changes as needed.
To change the table name, click [Rename] and enter the new name in the Formula table field.
To insert a row above the current row, click [Insert Row].
To delete a row, click the right mouse button in the leftmost cell of the row and select Delete Row from the shortcut menu.
To insert a column to the left of the current column, click [Insert Column]. Inserting a column in a one-dimensional table changes the table into a two-dimensional table.
(two dimensional table) To delete a column, click the right mouse button in the column’s input range cell and select Delete Column from the shortcut menu.
For more information, click
on the title
bar of the window, and then click a field or button.
- When you finish changing the formula table, click [OK] to save it.
- Change other formula tables in the same manner. When you finish, click [Close].