This tip was printed from the Tips for Spreadsheets website at

Microsoft Excel 2007 - Remove All Cell Formatting

After experimenting with Microsoft Excel 2007's various cell formatting features, you may later decide to remove all changes and start over.

For example, for business reasons, you may need to print or distribute an Excel spreadsheet free of any special formatting such as colors, fonts, and alignment.

To quickly remove all formatting from cells in an Excel 2007 spreadsheet:

1. Select the cell or cells where you want to remove formatting. Or, press Ctrl + A to select the entire worksheet.

2. Click the "Home" tab in the ribbon at the top of Excel 2007.

3. In the "Editing" group, click on the "Clear" pull-down and select "Clear Formats".

Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2007 - Remove All Cell Formatting.
Standard disclaimer applies - Read