Clear cell data in Excel 2007

You can clear the data in a cell by selecting the cell and pressing the Delete key. Remember that pressing the Delete key will remove the contents in the cell and not the formatting and comments (if applied to a cell). Excel provides you the option of clearing all the data that is in the cell (including content, format, comments) or clearing only the contents or clearing only the formats or comments.

To clear the data in a cell, perform the following:
1. Click to select the cell for which you need to clear the data.
2. On the Home tab, in the Editing group, click Clear. From the dropdown box, make a selection:
Clear All - This option will clear the contents, format, and comments.
Clear Formats - This option will clear the formats keeping the content and comments (if added).
Clear Contents - This option will clear the contents keeping the format and comments.
Clear Comments - This option will clear the comments only. The content and format will be present in the cell.

Note:
If the cell contains a comment, content, and some formatting applied. You can make the choice of removing the comment and formatting by clicking Clear and Clear Formats and again clicking Clear and Clear Comments.