Deleting Contents
Specifies the contents to be deleted from the active cell or from a selected cell range. If several sheets are selected, all selected sheets will be affected.
This dialogue box is also called by pressing Backspace after the cell cursor has been activated on the sheet.
Pressing Delete deletes content without calling the dialogue box or changing formats.
Use Cut on the Standard bar to delete content and formats without the dialogue box.
Selection
This area lists the options for deleting contents.
Delete All
Deletes all content from the selected cell range.
Text
Deletes text only. Formats, formulae, numbers and dates are not affected.
Numbers
Deletes numbers only. Formats and formulae remain unchanged.
Date & time
Deletes date and time values. Formats, text, numbers and formulae remain unchanged.
Formulae
Deletes formulae. Text, numbers, formats, dates and times remain unchanged.
Comments
Deletes comments added to cells. All other elements remain unchanged.
Formats
Deletes format attributes applied to cells. All cell content remains unchanged.
Objects
Deletes objects. All cell content remains unchanged.