remove all formats from a spreadsheet

  • Thread starter Thread starter Annie1904
  • Start date Start date
A

Annie1904

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?
 
Try it through VBA Immediate window:

Alt+F11 to open VBA
Ctrl+G to open Immediate window
Type in
cells.ClearFormats and press Enter

Regards,
Stefi

„Annie1904†ezt írta:
 
HI,

Go to menubar Edit>>Clear>>Formats>>Done
Save it if you dont then the formats will reappear when you reopen your file.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 
Hi Annie,

Depends on your version of xl.

For xl2007
Select the entire worksheet. (To do this, click in the square at the top
left of the worksheet where the column headers and row numbers meet.)
Click the drop down arrow against the Clear button in the Editing block (far
right of the Home ribbon). Select Clear formats.

Previous versions.
Select worksheet as above. Click menu item Edit -> Clear -> Formats.
 
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.
 
Back
Top