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
  #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
  #2  
Old May 6th, 2004, 09:37 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default "Extra" Rows and Columns

There are instructions here for manually or programmatically resetting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

Shane wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old May 7th, 2004, 11:47 AM
Shane
external usenet poster
 
Posts: n/a
Default "Extra" Rows and Columns

Debra,
Thanks! Worked like a charm!
Shane
-----Original Message-----
There are instructions here for manually or

programmatically resetting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

Shane wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 




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 08:14 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.