A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Extra" Rows and Columns



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 6th, 2004, 09:07 PM
Shane
external usenet poster
 
Posts: n/a
Default "Extra" Rows and Columns

Greetings,
A bunch of us are re-introducing ourselves to Excel 2000
at work and so far doing alright. We have noticed,
however, that while we're editing worksheets we'll
suddenly find that our LARGE/LONG scroll bar (sometimes
vertical, sometimes horizontal, sometimes both) has shrunk
to miniature size and suddenly our worksheet has a
gozillion rows and columns.

We're not concerned about printing, as we all know how to
use View\Page Break Preview, but it's awfully annoying to
try to navigate with a miniature scroll-bar and only a
viewable 1.5 pages of worksheet. We should have a
scrollbar that covers about 75% and go from there, but for
some reason it covers about 5%.

Sooo.. any ideas how to either prevent that (preferable)
or at least get RID of them?

Highligting a row, then hitting Ctrl + End just highlights
a single cell way down and over.. so we can't just do
that and delete the extra rows and columns.

Any help is appreciated!
Shane
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.