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 spreadsheet:
3. In the “Editing” group, click on the “Clear” pull-down and select “Clear Formats”.