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!
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!
Transcript of the video:
Welcome back to the MrExcel netcast, I'm Bill Jelen.
Today we have a question was sent in and I'm not positive that I have the best or the right answer and so I'm going to ask for help from anyone out there if you have a question or if you have input on this particular podcast please feel free to drop us an email at MrExcel.com.
The question that came in involves the scroll bar along the right hand side, so here I kind of minimize this window so you can see that basically in this case the scroll bar takes up almost half the window and you can very easily scroll through the portion of the spreadsheet that has data it's very easy to do, but if we would happen to go to the last row of data, hit the end key and then the down arrow keys that were the last row in the spreadsheet, now you see that the spreadsheet scrollbar slider has become incredibly small and it becomes a big hassle to basically even grab the things that we can go back up to the top of the spreadsheet, now it's interesting in Excel 2003 once I've gotten to the top of the spreadsheet it becomes normal size but sometimes we might have a data set in this case you can see there's 18 rows in the data set, yet the scrollbar remains incredibly small.
Now my one trick for this is that we want to see what the real last row of the spreadsheet is and the way that I do that; is I hit the end key the END key on the keyboard and then the HOME key and that takes us to what Excel believes is the real last cell in the spreadsheet, and in this case I have 18 rows of data but for some reason Excel thinks that the spreadsheet is alive out to J701, so what I'm going to do is I might actually delete those rows I'm going on the shift key and then up arrow to basically select row 701 through 19, now I'll use edit delete row entire row in order to delete those cells, it also believed that everything out to column J was alive so if you use CTRL home to go to the first cell there's two extra columns I and J; which are not filming this spreadsheet and we can delete those so edit delete column, now this in and of itself does not fix the problem we actually have to go to file save, and save the document and now you see that Excel realizes that our scrollbar comes back to normal size.
I wonder if you have any tricks for making the scrollbar come back to the right size after you've accidentally activated too many rows if you do let me know and we'll put it on a future podcast.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
Today we have a question was sent in and I'm not positive that I have the best or the right answer and so I'm going to ask for help from anyone out there if you have a question or if you have input on this particular podcast please feel free to drop us an email at MrExcel.com.
The question that came in involves the scroll bar along the right hand side, so here I kind of minimize this window so you can see that basically in this case the scroll bar takes up almost half the window and you can very easily scroll through the portion of the spreadsheet that has data it's very easy to do, but if we would happen to go to the last row of data, hit the end key and then the down arrow keys that were the last row in the spreadsheet, now you see that the spreadsheet scrollbar slider has become incredibly small and it becomes a big hassle to basically even grab the things that we can go back up to the top of the spreadsheet, now it's interesting in Excel 2003 once I've gotten to the top of the spreadsheet it becomes normal size but sometimes we might have a data set in this case you can see there's 18 rows in the data set, yet the scrollbar remains incredibly small.
Now my one trick for this is that we want to see what the real last row of the spreadsheet is and the way that I do that; is I hit the end key the END key on the keyboard and then the HOME key and that takes us to what Excel believes is the real last cell in the spreadsheet, and in this case I have 18 rows of data but for some reason Excel thinks that the spreadsheet is alive out to J701, so what I'm going to do is I might actually delete those rows I'm going on the shift key and then up arrow to basically select row 701 through 19, now I'll use edit delete row entire row in order to delete those cells, it also believed that everything out to column J was alive so if you use CTRL home to go to the first cell there's two extra columns I and J; which are not filming this spreadsheet and we can delete those so edit delete column, now this in and of itself does not fix the problem we actually have to go to file save, and save the document and now you see that Excel realizes that our scrollbar comes back to normal size.
I wonder if you have any tricks for making the scrollbar come back to the right size after you've accidentally activated too many rows if you do let me know and we'll put it on a future podcast.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
