Excel > Excel 2007 Foundation > Formatting a worksheet

Clear Cells

When you select a cell in Excel and press the delete key it only removes the contents of the cell. Any comments or formatting applied remain.

To clear a cell(s):

1. Select the cell(s)
2. Click the Home tab on the Ribbon
3. Click the Clear button in the Editing group



4. Select the desired option from the list

Format Painter Insert and delete rows, columns and cells

Guides