Excel 2007: Clear All Formatting From a Range of Cells

Posted August 4, 2008 by Rob Rogers in Microsoft Excel

If you have a spreadsheet that contains the data you desire, but the formatting isn’t to your liking, Excel can clear the formatting from a cell, range of cells, columns, rows or the entire spreadsheet.

1. Open the Excel spreadsheet containing the formatted data.

2. Select the range of cells that are to have the formatting removed by using either click and drag to select adjacent cells or by using ctrl+click and drag to select rows or columns or individual cells.

3. Go to the Ribbon, under the Home tab, and go to the Editing section.

4. Click the downward pointing arrow next to the Clear button and select Clear Formats.

The selected cells will have the formatting removed.


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • Winona

    Thanks so much had a brain cramp and could not remember where to go. This is appreciated. SL

  • Anonymous

    I tried to merge cells inside the formatted table and it couldn’t perform the task. I cleared the format and it still couldn’t be merged. Where did I do wrong?

  • Duncan Gretone

    With the programs that my workplace runs, we aren’t allowed to have “captions” under our icons, so I couldn’t recall how to clear the info in question. I had to be reminded that the “eraser” looking icon was what I sought. Thanks, and I’ll keep this description for future needs. Most excellent assistance!