Excel Clear Contents, Formats, or Entire Cell Shortcut

This tutorial will demonstrate shortcuts to clear cells in Excel.

Clear Cells in Excel

There are several different ways to clear cells in Excel. We will review a few in this tutorial.

Clear Cell Contents

Clear Cell contents removes the text within a cell.

• The shortcut for this is pressing the DELETE button on your keyboard.
  PC Shortcut: Delete
  Mac Shortcut: fn+Delete

See the image below, for an example of clearing cell contents:

Clear Cell Formatting

To clear only cell formatting, use the shortcut:

This will clear the formatting and leave the text, as shown below

Clear All

• To remove both formats and contents, select the cell and use the shortcut:
  PC Shortcut: ALT>H>E>A

Clearing all will clear everything, as shown below.