Have you tried selecting all cells and EditClearFormats


Gord Dibben MS Excel MVP

On Thu, 22 Apr 2010 20:24:01 -0700, Tom
wrote:

FSt1, thanks but when I try to do exactly that I get the answer "too many
different cell formats" - it seems something is preventing me from making the
changes even though I want to redo the sheet in the basic formatting as per
your instructions.


"FSt1" wrote:

hi
the sheet may look blank but did you just delete data. deleting data does
not delete formating. that is the most common mistake that users make. they
end up with "blank" cells but the cells still carry the previous formating.
and technically you can't remove all formating. each cell must have at least
the default formating.
select the sheet by clicking the small square at the upper right of the
sheet. left of the column header and above the row headers.
right click the selected sheet and click format cells.
set the number format to general
set the fond to Arial(or your faviorate.)
remove all font colors(set to automatic)
remove all borders(set to none)
remove all background colors(set to no fill_
you might even unwrap all cells and unmerge cells(if there are any)

after all that, the sheet should be fairly default.

Regards
FSt1

"Tom" wrote:

In fact I just tried to use the autoformat function and have "none" set up
for the whole spreadsheet and the answer is still "too many different cell
formats".
Seems a bit silly to tell me this but not to allow to simplify the worksheet.