Clearing Cell Content
If you want to remove the contents of a cell without removing the cell from the structure of your workbook, you will need to clear the cell. In Excel, when you clear a cell, you remove its contents, formats, or comments, but the blank cell remains in the worksheet. Clearing a cell does not affect the layout of your worksheet.
To clear a cell:
- Select the cell you want to clear of formats or contents.
- Point to Clear on the Edit menu, and click Formats, Contents, Comments, or All.
Deleting a cell will remove it from the structure of your workbook, thus affecting all surrounding cells.
If you clear a cell containing numbers, the new value of the cleared cell is 0, and is reflected in all formulas as such.
Using the
or
key on the keyboard removes the cell contents but does not remove comments or cell formats. These keyboard shortcuts do not work with the simulated interface in this program.