[mso] Re: Excel Scroll Bar

  • From: Linda Johnson <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Thu, 16 May 2002 16:07:22 -0400

Oh...I misunderstood, Eric....if your scroll bar is indicating you have
a huge file and you don't, that means Excel thinks you have something in
a cell waaaaaaaayyyy down.....and you might or might not (Excel
considers a space in a cell as something)

When you hit ctrl+end, where does Excel jump to?  If it's a cell that's
way past the end of your actual data, then this is what's happening

Just highlight all the cells from the end of your data up to and
including the cell that Excel sees as the end of your data and go to the
Edit menu and choose Clear>All....if that doesn't fix it, then highlight
your data and copy/paste it into a new workbook and that should fix it

Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com/main.htm
Author/Teacher ~ MS Office EBooks/Classes
http://personal-computer-tutor.com/services.htm
 


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Eric Skeen
Sent: Thursday, May 16, 2002 3:12 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Scroll Bar



Thanks Linda, I have been doing that, but just wondered out of curiosity
if
there is a way of "re-setting" the vertical scroll bar.

I simply hate it when the scroll bar indicates a massive file when the
file
is not that large.

Curiosity killed the cat...

*************************************************************
PLEASE READ!!!!

You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx 
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

//www.freelists.org/webpage/mso
*************************************************************

Other related posts: