# Editing a Spreadsheet Cell

In addition to editing the formulas contained in individual cells, you can cut, copy, paste or delete cells or adjust cell formatting.

Note:

- Right-clicking within the spreadsheet displays a shortcut menu that allows various spreadsheet operations to be performed.
- During a cut-and-paste operation, the contents of the cut cell may be lost if an error occurs, even if the Cancel button is pressed to stop the operation. In this scenario, use Undo (CTRL+Z) to restore the contents of the cut cell.

### Editing numbers and text

To edit a numeric value or text in the active cell, press the ENTER or EQUALS key. You can also simply type over the number or text, but this will erase the previous number or text.

### Editing cell references

To change a cell reference, simply follow the steps for inserting a cell reference.

### Editing functions

Functions can be edited in the property sheet (if available) or in the spreadsheet.

- If the function has an associated property sheet, double-click on the cell or press the ENTER key on the active cell to automatically launch it.

- To edit the function in the active cell, rather than in a property sheet, press F2 or the EQUALS key.

  Press the UP or DOWN ARROW key to display the function box below the formula. Press the RIGHT or LEFT ARROW key to move the cursor within the formula. To change to a different formula, position the cursor in the function name, use the DOWN ARROW to open the function box and select the desired function. Press either the TAB or ENTER key to make the selection and close the function box.

  Note: Based on the location of the cursor, only the functions that are valid for that particular expression in the formula will be listed in the function box.
  - To choose a different function, select the cell and type the name of the desired function.