If you are looking to clear all formatting on an Excel spreadsheet, then Excel 2007 has just the feature.

Click the ‘Home’ tab in the ribbon, click on the ‘Clear’ icon in the ‘Editing’ section, and select ‘Clear Formats’

image

Nice and simple, and very useful.

This is my site Written by Tim Jolley on March 19, 2011 – 10:21 am