Back in Episode 548, I talked about the frustrating size of the scrollbar slider when you accidentally activate a cell that is outside of the normal range. Derek from the UK sends in a great solution in todays podcast. Episode 565 shows the completely unintuitive way to solve this problem.
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:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today we're going to follow up on episode 548.
548 is where we talked about the scrollbar size and we talked about if you have a short data set, you could basically use the scroll bar to scroll through the entire data set.
So, here I can look at all 39 rows the scrollbars nice and large.
But unfortunately, if we would accidentally activate a cell, at the bottom of the spreadsheet.
I'll put an x in here and then delete that x.
So, now you know at one point that cell was alive now, it's not anymore.
We have the problem that the scroll bar has now become incredibly small, and as I drag it just a few pixels, I'm already down at Row 350.
It becomes completely impossible to use the scroll bar anymore, for navigating to the top and bottom of the cell.
In episode 548, I said that my trick was to delete the extra rows and then save the worksheet.
That would allow the scroll bar to become bigger.
Derek from the UK send in a great tip.
He said once you get rid of that extra cell at the bottom, then all you need to do is control drag the sheet, this creates a copy of the sheet and then both sheets.
The original sheet and the new sheet have the proper scrollbar.
Somehow, the process of copying the sheet makes Excel look and say oh, well, there's nothing being used below this point.
So, we'll make the scrollbar go back to the original size.
So, it's just as simple as copying the sheet.
And of course the fast way to copy the sheet is, to control drag the sheet tab to a new spot.
Thanks to Derek from the UK.
I'm sending one of my excel master pins, for that great idea.
If you have a question for the podcast, please feel free to drop me an email bill@mrexcel.com.
And we'll get to you on a future podcast.
Thanks for stopping by.
See you next time for another netcast from MrExcel.
I'm Bill Jelen.
Today we're going to follow up on episode 548.
548 is where we talked about the scrollbar size and we talked about if you have a short data set, you could basically use the scroll bar to scroll through the entire data set.
So, here I can look at all 39 rows the scrollbars nice and large.
But unfortunately, if we would accidentally activate a cell, at the bottom of the spreadsheet.
I'll put an x in here and then delete that x.
So, now you know at one point that cell was alive now, it's not anymore.
We have the problem that the scroll bar has now become incredibly small, and as I drag it just a few pixels, I'm already down at Row 350.
It becomes completely impossible to use the scroll bar anymore, for navigating to the top and bottom of the cell.
In episode 548, I said that my trick was to delete the extra rows and then save the worksheet.
That would allow the scroll bar to become bigger.
Derek from the UK send in a great tip.
He said once you get rid of that extra cell at the bottom, then all you need to do is control drag the sheet, this creates a copy of the sheet and then both sheets.
The original sheet and the new sheet have the proper scrollbar.
Somehow, the process of copying the sheet makes Excel look and say oh, well, there's nothing being used below this point.
So, we'll make the scrollbar go back to the original size.
So, it's just as simple as copying the sheet.
And of course the fast way to copy the sheet is, to control drag the sheet tab to a new spot.
Thanks to Derek from the UK.
I'm sending one of my excel master pins, for that great idea.
If you have a question for the podcast, please feel free to drop me an email bill@mrexcel.com.
And we'll get to you on a future podcast.
Thanks for stopping by.
See you next time for another netcast from MrExcel.
