Before deleting the content of a cell or cell range, you
must first select the cell or range. Similarly, if several sheets
are selected, the deletion in one sheet affects all the selected sheets.
Pressing the Delete or Backspace keys to delete the content does not
display the Delete Contents window.
To specify the content to be deleted, perform the following
steps:
- Select the cell or range from which you want to delete
the contents.
- Choose from the main menu. The Delete
Contents window displays.
- Select the type of content such as delete all, strings,
numbers, date & time, formulas, comments, formats or objects,
to delete in the Selection area.
- Click OK.