A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Resize scroll bar



 
 
Thread Tools Display Modes
  #1  
Old January 14th 05, 01:57 PM
Duncan Help
external usenet poster
 
Posts: n/a
Default Resize scroll bar

The scroll bars at the side and bottom of my spreadsheet take me to much
lower then the bottom of my data now because I have recently made the
spreadsheet a little smaller. Is there a way to re-size these to better
reflect where the data is?
Ads
  #2  
Old January 14th 05, 02:48 PM
Jim Rech
external usenet poster
 
Posts: n/a
Default

If you press Ctrl-End you'll go to the end of the "used range". You should
select and delete (Edit, Delete) the empty rows and column between that
point and the end of your data. Then save the workbook. The used range
should then be shrunk and the scroll bars should resize to reflect that.

--
Jim Rech
Excel MVP
"Duncan Help" > wrote in message
...
| The scroll bars at the side and bottom of my spreadsheet take me to much
| lower then the bottom of my data now because I have recently made the
| spreadsheet a little smaller. Is there a way to re-size these to better
| reflect where the data is?


 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
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 10:12 PM
Excel, horizontal scroll bar and sheets not accessable anymore Cassandra Excel Discussion (Misc queries) 4 December 18th 04 06:01 PM
scroll bar Yevgeny Azrieli Excel Discussion (Misc queries) 1 December 16th 04 06:39 PM
Scroll Bar in Shared workbook Ronil Patel Excel Discussion (Misc queries) 2 December 8th 04 02:49 AM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 09:55 PM


All times are GMT +1. The time now is 05:27 PM.


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