Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2000, how do I add a vertical scroll bar to a split scre. | Excel Discussion (Misc queries) | |||
Excel, horizontal scroll bar and sheets not accessable anymore | Excel Discussion (Misc queries) | |||
scroll bar | Excel Discussion (Misc queries) | |||
Scroll Bar in Shared workbook | Excel Discussion (Misc queries) | |||
How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel |