Prev: Please Clarify
Next: View Hyperlink in another cell
From: M on 13 Jan 2010 09:57
I have a file with about 180k of data in

I want to format the columns (about 20 columns) with background colour
and borders, all the way to the bottom, but it changes the file size
from 180k to 180M - is this normal?

Is there a way I can have the formatting without the file-bloat?

Thanks

M
From: Gord Dibben on 13 Jan 2010 11:21
Not normal.

Excel 2007

Open a new workbook and save........size 7.65kb

Format the 20 columns as you say.

Save workbook.............size 7.83 5kb

You have something else going on.

Select the columns and hit spacebar then CTRL + Enter.

Save..............size 70Mb


Gord Dibben MS Excel MVP

On Wed, 13 Jan 2010 06:57:33 -0800 (PST), M <michael.holness(a)googlemail.com>
wrote:

>I have a file with about 180k of data in
>
>I want to format the columns (about 20 columns) with background colour
>and borders, all the way to the bottom, but it changes the file size
>from 180k to 180M - is this normal?
>
>Is there a way I can have the formatting without the file-bloat?
>
>Thanks
>
>M

From: Niek Otten on 13 Jan 2010 11:40
Format the whole (group of) columns in one go (select them all and then
format).
If you format one cell and then copy that format to the other cells, the
file explodes.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"M" <michael.holness(a)googlemail.com> wrote in message
news:ec2dfa21-1281-41e0-a933-52d2fbb0e724(a)b2g2000yqi.googlegroups.com...
>I have a file with about 180k of data in
>
> I want to format the columns (about 20 columns) with background colour
> and borders, all the way to the bottom, but it changes the file size
> from 180k to 180M - is this normal?
>
> Is there a way I can have the formatting without the file-bloat?
>
> Thanks
>
> M

 | 
Pages: 1
Prev: Please Clarify
Next: View Hyperlink in another cell