Erasing the contents of a cell

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 dropdown 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.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>