Changing the cells in an item table
You can use the commands on the
to change the input ranges, items to return, or calculation methods in
an item table. These commands are available from the grid in the Item
Table window.
To change a value, right-click the cell, and then choose
one of the following commands.
- Insert
Row inserts a blank row. Before inserting a row, you need to
click a cell in the grid.
- Insert
Column inserts a blank column. Before inserting a column, you
need to click a cell in the grid. This turns a one-dimensional table into
a two-dimensional table.
- Substitute
Item inserts the selected item into the current cell.
- Delete
Item removes the item from the current cell.
- Edit
Calculation allows you to set up a special formula for the item.
- Delete
Calculation -removes the calculation from the current cell. You
can then set up a custom calculation for the item.
The command is available from the columns containing the
item formula. To see these columns, select the Show calculation column option.