I have a huge pet peeve in Excel. As your spreadsheet grows both vertically and horizontally, the scroll bar accommodates this growth as needed. However, if you were to delete columns and/or rows, the scroll bars stay at the maximum bounds. Am I making sense? lol. Is there a way to reset the scroll bars so when you grab the scroll bar and pull it to the bottom, it goes to the last entry currently in the spreadsheet, not the cell where the maximum last entry was? lol, I really hope this makes sense.....
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Scroll bar annoyance
- Thread starter trufooser
- Start date
DominicB
Well-known Member
- Joined
- Oct 3, 2005
- Messages
- 1,569
Good morning trufooser
To sort this out you need to delete the rows (not the information) between the last row of your actual data and the point at which the scroll bar thinks is that last row of your data.
Alternatively, my add-in available via the link below, has a utility that will do this for you across all worksheets in a workbbok. Just go to Ultimate > Optimise > Optimise Worksheets.
Whichever way you choose the workbook will need to be saved and reopened for the changes to be apparent. You will also notice a difference in the size of the file.
HTH
DominicB
To sort this out you need to delete the rows (not the information) between the last row of your actual data and the point at which the scroll bar thinks is that last row of your data.
Alternatively, my add-in available via the link below, has a utility that will do this for you across all worksheets in a workbbok. Just go to Ultimate > Optimise > Optimise Worksheets.
Whichever way you choose the workbook will need to be saved and reopened for the changes to be apparent. You will also notice a difference in the size of the file.
HTH
DominicB
Upvote
0
steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
Look on page 3:
http://www.mrexcel.com/board2/viewtopic.php?t=252906&postdays=0&postorder=asc&&start=20
Use Edit>Clear>All instead
http://www.mrexcel.com/board2/viewtopic.php?t=252906&postdays=0&postorder=asc&&start=20
Use Edit>Clear>All instead
Upvote
0
Similar threads
- Question
