Increasing File Size

[April]

I cut and paste from a website into an excel worksheet and
the filesize increases to 3, 4, 5 MB's. Does anyone know
of a way to turn off the "behind-the-scene" coding?

 

[Ron de Bruin]

Try this

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it

 

[Lady Layla]

Paste special and just paste values

: I cut and paste from a website into an excel worksheet and
: the filesize increases to 3, 4, 5 MB's. Does anyone know
: of a way to turn off the "behind-the-scene" coding?

 

[David McRitchie]

Hi April,

Paste special and just paste values -- Lady Layla
Excel can think that the usedrange is bigger then it is. -- Ron de Bruin

Good answers. Most of the problem is in the round tripping
code in MS Office applications which attempts to preserve
anything touched by any office program so it can be
brought back to that office application later intact. It is
a preposterous assumption especially for people on dial ups.

When you paste from HTML you may be including nonbreaking
spaces (&nbsp, which you might want to convert to spaces
and trim. I'm not sure what you will get with paste values but
TrimALL macro has proven very useful for fixing up a lot of
such problems.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

If you want to preserve a bit more information, like font color
(one font per cell), bold, limited fontsize changes, You could
paste into a different worksheet, and use the macro in
http://www.mvps.org/dmcritchie/excel/xl2html.htm
to create a simple html page and then copy and paste from
that into your Excel. Be aware that Excel has only 56 colors
so may not match the html page unless they chose "safe" colors.