formating problem

Tony Miall

Active Member
Joined
Oct 16, 2007
Messages
304
Afternoon,

I am trying to decrease the size of a file by clearing all the formating in about 20,000 cells but for some reason when I format the range to no fill, no colour, no bold etc etc instead of decreasing the file size it increases from 7000KB to 41,000KB and I don't understand why. Any help appreciated as usual.

thanks
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,282
Office Version
  1. 365
Platform
  1. Windows
Tony

Do you want to clear all formatting from the worksheet(s), or just some of it?

If you want to clear it all there is an option to do it, in Excel 2010 you'll find it in the Editing section of the ribbon under Clear.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,683
Messages
5,637,773
Members
416,982
Latest member
lisam77

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top