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 > FormulasFormula Tables.
  2. Click Image of the List button, 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, click the right mouse button in the column’s input range cell and select Delete Column from the shortcut menu.

      For more information, click An image showing the Help icon available on the ribbon 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. When you finish, click [Close].