the Clear Command

The Edit Clear command has four options

the Clear Command Submenu Excel XP	the Clear Command Submenu Excel X

• Edit Clear All
  • when selected, this option will clear (“delete”) anything in or attached to the selected cell(s)
  • any data, comments and formats added to that cell(s) will be deleted!
• Edit Clear Formats
  • when selected, this option will clear (“delete”) any formatting added to the cell(s) selected
  • any data or comments added to that cell(s) will remain
• Edit Clear Contents
  • when selected, this option will clear (“delete”) any data in the cell(s) selected
  • any formats or comments added to that cell(s) will remain
  • this is the same as pressing the <Backspace> or <Delete> keys
• Edit Clear Comments
  • when selected, this option will clear (“delete”) any comments added to the cell(s) selected
  • any data or formats added to that cell(s) will remain

Comparing the Delete and Clear Commands

You must understand the differences between the Clear command described above and Deleting Columns/Rows. When you use the Edit Clear command

• the column(s) and/or row(s) remain but
  • the data in the cells is deleted
  • or the formatting attached to the cells is deleted
  • or comments attached to the cells is deleted
  • or any combination of the above

When you use the Edit Delete command, not only are the cells cleared but the column(s) or row(s) are also deleted.

Go Back

Copyright©2003
last updated August 12, 2003