Erasing the contents of a cell

You can erase the contents of a cell. To do this, activate the cell you wish to delete (usually by clicking on it), and then press the del key. This will delete everything in the cell, including contents and format.

If you wish to delete particular features of the cell while leaving others intact, select the Clear command from the Edit menu. The "Clear" dialog will appear.

In this dialog, you are given five choices:

All

Erases everything from the cell.

Values

Erases the value from the cell, leaving formulas and formats intact.

Formulas

Erases only a formula from the cell - the result of the formula will be left intact.

Contents

Erases only the contents of the cell, that is values and formulas; anything else you put in this cell will take on the existing formatting.

Format

Erases only the formatting of the cell – the contents will be left intact.

You can also access Clear by right-clicking your mouse, although the options to clear formulas and values are not available in this way.

Select the option you require, and click on the OK button.