Deleting

To delete the contents of selected cells (that is just the data in the cell, and none of the formatting), press Delete.This opens the Delete Contents dialog, from which you choose the contents of the cell you want to delete, such as Formats, Numbers, Formulas, or Objects.

To delete the contents of selected cells without calling the dialog, press Backspace. This deletes neither cell formatting nor objects.

To delete all the contents of selected cells (including formats and objects) without calling the dialog, press Control+X or select Edit > Cut.