Prev: help with Conditional formatting pairs of cells
Next: reference sheet number not name
From: DaveMoore on 28 Jan 2010 12:14
I have found that deleting ALL columns to the right of my required
data and ALL rows below was effective in removing unwanted
formatting. Crude perhaps, but it works.
Just today I reduced a 4mb s/sheet to 275k.

Best o' luck


On 28 Jan, 16:47, JDH <J...(a)discussions.microsoft.com> wrote:
> I have a file that has cols a-p, rows 1-40.   Had a lot of colors and stuff
> but I cleared all formatting and saved file.   Still 4mb.   Can't figure out
> where the issue is.   Can anyone help?

From: Gord Dibben on 28 Jan 2010 14:20
Important rider.

After the unused row and column deletions you must SAVE the workbook.

I some earlier versions you had to Save, Close and re-open to effect change.


Gord Dibben MS Excel MVP


On Thu, 28 Jan 2010 09:14:49 -0800 (PST), DaveMoore
<david.moore(a)uuplc.co.uk> wrote:

>I have found that deleting ALL columns to the right of my required
>data and ALL rows below was effective in removing unwanted
>formatting. Crude perhaps, but it works.
>Just today I reduced a 4mb s/sheet to 275k.
>
>Best o' luck
>
>
>On 28 Jan, 16:47, JDH <J...(a)discussions.microsoft.com> wrote:
>> I have a file that has cols a-p, rows 1-40. � Had a lot of colors and stuff
>> but I cleared all formatting and saved file. � Still 4mb. � Can't figure out
>> where the issue is. � Can anyone help?

 | 
Pages: 1
Prev: help with Conditional formatting pairs of cells
Next: reference sheet number not name