Excel grows in size after using [Fill Color]
Posted by Danny Robinson on May 05, 2001 12:36 AM
My XLS has grown from 1Mb to over 8Mb after selecting
[No Fill] from [Fill Color] on Formatting ToolBox
on a range below used cells to the end of the sheet.
I've worked on the 30 sheets within one XLS and I want
to "clean" out unwanted formatting and then re-apply
only the background fill colors where they're needed.
Is there a macro that 'copies' sheets to a new sheet
without copying all of the formatting, or better,
copies everything except the fill color I've used.
I've tried 'Save As' but it still is too large.