You may not want to clear all the formats.

If you have dates, times, phone numbers, or currency, you may want to be more
selective and remove the formatting that you don't care about.

Select all the cells
Ctrl-1
Change as much as you want (borders/fonts/borders/...)

And you may want to remove conditional formatting, too.



Annie1904 wrote:

In one of my busy spreadsheets I have too many formats and I want to get rid
of/remove them. I have cleared out the formats as best as I can but as soon
as I try to sort the spreadsheet it comes back with too many formats.

Any ideas on how to remove all formats from a spreadsheet completely and
return it to the default state?

--

Dave Peterson