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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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 | |
|
|