| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
Welcome back to another episode of the MrExcel netcast. I’m Bill Jelen and today we have a question from one of our viewers regarding the size of the scrollbar in Excel. I’m not entirely sure if my solution is the best or most efficient, so I’m reaching out to all of you for your input. If you have any suggestions or tips, please don’t hesitate to email us at MrExcel.com.
The issue at hand is the scrollbar on the right-hand side of the spreadsheet. As you can see, when the window is minimized, the scrollbar takes up almost half of the window. It’s easy to scroll through the data in the spreadsheet, but the problem arises when we reach the last row of data. The scrollbar becomes incredibly small and it becomes a hassle to navigate through the spreadsheet. Even when we go back to the top of the spreadsheet, the scrollbar remains small. This can be frustrating, especially when dealing with large datasets.
My go-to solution for this problem is to determine the real last row of the spreadsheet. To do this, I use the END key on my keyboard followed by the HOME key. This takes me to the cell that Excel believes is the last cell in the spreadsheet. In this case, it shows that there are 18 rows of data, but for some reason, Excel thinks the spreadsheet goes all the way to row 701. To fix this, I simply delete the extra rows and columns that are not being used. Once I save the document, the scrollbar returns to its normal size.
Do you have any other tricks or methods for resizing the scrollbar after accidentally activating too many rows? If so, please share them with us and we’ll feature them in a future netcast. Thanks for tuning in and we’ll see you next time for more Excel tips and tricks from MrExcel.
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/
If you navigate your worksheet rows by dragging your scrollbar slider, in some Excel worksheets, the scrollbar slider becomes incredibly small. In Episode 548, I show my one trick for solving this problem, but I expect that there are other solutions.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Table of Contents:
(00:00) Introduction
(00:17) Question from a viewer
(00:30) Issue with scroll bar size
(00:45) Difficulty scrolling to last row of data
(01:18) Solution: using END and HOME keys
(01:44) Deleting extra rows and columns
(02:11) Saving the document to fix the scroll bar size
(02:25) Request for additional tips/tricks
(02:36) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Deleting extra rows and columns in Excel
End key and home key in Excel
Excel scroll bar becomes small after reaching last row
Excel thinks spreadsheet extends to J701
How to fix small scroll bar in Excel
How to resize scroll bar in Excel
Resolving scroll bar size issue in Excel
Saving to fix scroll bar size issue in Excel
Scroll bar size issue in Excel
Scroll bar taking up half the window
Tips for managing scroll bar in Excel
Tricks for resizing scroll bar in Excel
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152544/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
