Hard to describe problem

B

Boots

My problem is certainly not major but it creates a bigger
problem.

I am running XP Home SP1 using Excel 2002 SP3. I have an
Excel file with 3 sheets. The first sheet is the
problem. The data in this sheet includes cells A1 to
Z45.

When I hit Ctrl-Home, cell A1 is selected as it should.
When I hit Ctrl-End, cell Z10000 is selected. With all
of the extra cells saved, it significantly increases the
size of the file from a few hundred KB to 1-2 MB.
Because of this, it can affect whether I can email the
file since some servers will reject files that are too
large.

I have looked for many solutions without success. I
don't know what to search for to fix it. My question is,
how can I eliminate the unnecessary cells when the file
is saved so when I hit Ctrl-End, cell Z45 is selected
instead of Z10000?

Thank you in advance for any input.

B
 
R

RagDyer

Select the *entire* column AA, then:
<Ctrl> <Shift> <RightArrow>

This should select all columns out to column IV.
Right click in the selection and choose <Delete>

Now, select the *entire* row 46, then:
<Ctrl> <Shift> <DownArrow>

This should select all rows down to row 65536.
Right click in the selection and choose <Delete>

Click <Save>, and do your
<Ctrl> <End>

And see where you end up.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


My problem is certainly not major but it creates a bigger
problem.

I am running XP Home SP1 using Excel 2002 SP3. I have an
Excel file with 3 sheets. The first sheet is the
problem. The data in this sheet includes cells A1 to
Z45.

When I hit Ctrl-Home, cell A1 is selected as it should.
When I hit Ctrl-End, cell Z10000 is selected. With all
of the extra cells saved, it significantly increases the
size of the file from a few hundred KB to 1-2 MB.
Because of this, it can affect whether I can email the
file since some servers will reject files that are too
large.

I have looked for many solutions without success. I
don't know what to search for to fix it. My question is,
how can I eliminate the unnecessary cells when the file
is saved so when I hit Ctrl-End, cell Z45 is selected
instead of Z10000?

Thank you in advance for any input.

B
 
B

Boots

RD,

I'm not sure if my first note of gratitude made it since
IE hung after I sent the post.

Your instructions worked *exactly* as you mentioned. I
appreciate your very prompt reply.

B
 
O

opeel

and another way..........
from the immediate panel of the Visual Basic window type:-
activesheet.usedrang
 
R

RagDyeR

Thanks for the feedback.

However, I'm slightly confused about something you said in one of your
posts.

Did I understand you correctly, that you *had* to close and reopen XL before
the resize took effect?

Since you stated in your OP that you're using XL02, I didn't make any
mention of having to close and reopen XL after the initial save after the
resize.
This is because it shouldn't really be necessary for your version.

From XL97 forward, a save should be all that's necessary to complete the
resize.

Did you try a <Ctrl> <End> immediately after the initial save?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


RD,

I'm not sure if my first note of gratitude made it since
IE hung after I sent the post.

Your instructions worked *exactly* as you mentioned. I
appreciate your very prompt reply.

B
 
Top