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: DeleteMac 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
- 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.