remove all formats from a spreadsheet
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:
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?
|