Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 16th 05, 11:17 PM
suefallston
 
Posts: n/a
Default How do I limit the vertical scroll?

In some worksheets, I may have 50 or 100 entires, yet the vertical scroll
will sometimes take me well into the thousands. Is there a way to limit the
vertical scroll to just my data entered? I am using Excel 2003, Basic Office
Edition with XP. Thanks.

  #2   Report Post  
Old March 17th 05, 12:04 AM
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish has some notes and pictures at:
http://www.contextures.com/xlfaqApp.html#Unused

If hitting ctrl-End takes you way past what you think should be the last cell,
you'll want to check it out.

suefallston wrote:

In some worksheets, I may have 50 or 100 entires, yet the vertical scroll
will sometimes take me well into the thousands. Is there a way to limit the
vertical scroll to just my data entered? I am using Excel 2003, Basic Office
Edition with XP. Thanks.


--

Dave Peterson
  #3   Report Post  
Old March 17th 05, 12:42 AM
suefallston
 
Posts: n/a
Default

Dave-

Thanks so much. Easy solution to an annoying problem.

Sue

"Dave Peterson" wrote:

Debra Dalgleish has some notes and pictures at:
http://www.contextures.com/xlfaqApp.html#Unused

If hitting ctrl-End takes you way past what you think should be the last cell,
you'll want to check it out.

suefallston wrote:

In some worksheets, I may have 50 or 100 entires, yet the vertical scroll
will sometimes take me well into the thousands. Is there a way to limit the
vertical scroll to just my data entered? I am using Excel 2003, Basic Office
Edition with XP. Thanks.


--

Dave Peterson

  #4   Report Post  
Old March 17th 05, 12:58 AM
Gord Dibben
 
Posts: n/a
Default

Sue

Excel often over-estimates the actual "used range" due to data being entered
then deleted.

Where does CTRL + END take you?

If far below and to the right of what you know is your real used range, go to
the row after the last row of real data then SHIFT + END + DownArrow to select
all rows below your data.

Now..........EditDeleteEntire Row(do not just clear contents, delete)

Do same for columns to the right of your data.

NOW IMPORTANT...Save the workbook. Close and re-open to see changes.

Hit CTRL + END to see that the used range is what you set it for.


Gord Dibben Excel MVP



On Wed, 16 Mar 2005 15:17:02 -0800, "suefallston"
wrote:

In some worksheets, I may have 50 or 100 entires, yet the vertical scroll
will sometimes take me well into the thousands. Is there a way to limit the
vertical scroll to just my data entered? I am using Excel 2003, Basic Office
Edition with XP. Thanks.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
horizontal & vertical scroll bars labrev Excel Worksheet Functions 2 February 21st 05 03:49 PM
In Excel 2000, how do I add a vertical scroll bar to a split scre. Lisa_196 Excel Discussion (Misc queries) 1 January 13th 05 09:12 PM
How do I restrict any one not to scroll more than 100 row? Saadi Excel Worksheet Functions 1 January 7th 05 07:25 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 05:39 PM
Scroll bars (vertical and horizontal). Doc Excel Discussion (Misc queries) 2 December 7th 04 03:33 PM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017