MrExcel's Learn Excel #565 - Restoring Scrollbar

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 6, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top