How to Clear Cell Formats or Contents in MS Excel XP

August 1, 2008 by Jules · Leave a Comment
Filed under: Excel 

To clear cell formats or contents in MS Excel XP:

  1. Choose the cells, rows, or columns whose formatting or contents should be deleted
  2. Click the Edit menu, select Clear option and then click Formats or Contents options.
  3. Clear cell format in Excel
  4. To clear both formats and contents, and any cell comments or cell validation, Click the Edit menu, select the option Clear, and then select the option All.