I am using excel 2007 with 64bit windows 7
I am unable to clear the formatting of rows or columns in a spreadsheet.
If I change the default column width and/or row width then Ctrl-A to select the whole sheet then go to the Home tab and under Editing click Clear and select either Clear All, then all formatting is cleared except the column and row widths. If I use Clear Formats, nothing happens. Any ideas why not? I have tried this on both new and existing spreadsheets and get the same result for each.
Is there any other way to reset the column and row widths?
Bookmarks