Clear Cell Contents or Formats in Excel

Question

How do I clear cell contents or formats in Excel?

Answer

You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), and any attached comments. The cleared cells remain as blank or unformatted cells on the worksheet.

1. Select the cells, rows, or columns that you want to clear. To cancel a selection of rows or columns, click any cell on the worksheet.
2. In the Editing group, point to Clear, and then do one of the following:
   1. To clear everything that is contained in the selected cells, click All
   2. To clear only the formats that are applied to the cells, click Formats
   3.  To clear only the contents, leaving any formats and comments in place, click Contents
   4. To clear any comments that are attached to the selected cells, click Comments

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.