After you enter a value or text into a cell, you can modify it in several ways:
Erase the cell’s contents
Replace the cell’s contents with something else
Edit the cell’s contents
To erase the contents of a cell, just click the cell and press Delete. To erase more than one cell, select all the cells that you want to erase and then press Delete. Pressing Delete removes the cell’s contents but doesn’t remove any formatting (such as bold, italic, or a different number format) that you may have applied to the cell.
For more control over what gets deleted, you can choose Home Editing Clear. This command’s drop-down list has four choices:
Clear All: Clears everything from the cell
Clear Formats: Clears only the formatting and leaves the value, text, or formula
Clear Contents: Clears only the cell’s contents and leaves the formatting
Clear Comments: Clears the comment (if one exists) attached to the cell
Clearing formats doesn’t clear the background colors in a range that has been designated as a table, unless you’ve replace the table style background colors manually.
To replace the contents of a cell with something else, just activate the cell and type your new entry, which replaces the previous contents. ...