Editing formula

A formula can be edited in the same way as any other entry in a cell.

To delete a cell reference or any other character, select it and press the Backspace or Delete key.

To replace a cell reference, select it and click in the replacement cell.

To add to the formula, position the insertion point where the extra characters are to go and type them in.

To undo changes that have not been locked in, press the Esc key or click the Cancel button (red cross) on the formula bar.

To undo changes that have been locked in, click the Undo button on the Standard toolbar, press Ctrl/Z or select Undo from the Edit menu.