In addition to the options for editing tables in general described in the Editing a Table chapter, there are functions available to adjust the values of several cells. Select the appropriate cells as a 'Selection', for example, by dragging the pointer over several table rows while holding down the left mouse button. Clicking on a table header selects the entire table column, and clicking on a row number selects the entire table row.
It is not important whether the cells are empty or not. Use one of the editing functions on the 'Selection' menu to change the contents of selected cells. The functions are described in the following table. They are also available as buttons and in the shortcut menu of the selected cells.
| Function | Button | Effect |
|---|---|---|
| Delete |
|
Deletes all of the contents of the selected cells. |
| Add |
|
Adds/subtracts a value to/from cells that contain numerical values. |
| Multiply |
|
Multiplies cells that contain numerical values by a specified factor. |
| Divide |
|
Divides cells that contain numerical values by a divisor. |
After selecting the corresponding function, the 'Operation' dialog box appears. Enter the addend, factor, or divisor.
