Changing an existing formula table

1. Open the Formula Table window in one of the following ways:

   • On the ribbon, from the Calculations group on the Data tab, click Formula Tables.
   • In classic view, click Database menu > Formulas > Formula Tables.
2. Click , and then select the formula table you want to change.
3. 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, right-click in the column’s input range cell and then 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.

4. When you finish changing the formula table, click [OK] to save it.
5. Change other formula tables in the same manner.
6. When you finish, click [Close].