MrExcel's Learn Excel #608 - Navigate Worksheets

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 Apr 7, 2009.
Learn how to quickly navigate worksheets. Episode 608 shows you how.

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.
Well it's another Friday.
So let me give you another quick tip.
This is one that no one necessarily sent in a question for but anytime I'm doing a seminar almost everyone catches me doing this and they think it's a cool tip they say, wait a second.
How are you flying from sheet to sheet to sheet to sheet so fast?
So you see here we have we have several worksheets and I can very quickly jump up and down from sheet to sheet to sheet.
Well the trick to this is to hold down the Ctrl key and use page up and page down.
If you do Ctrl page down you'll move to the right of the sheets and Ctrl page up will move you to the left.
So if you ever need to jump from sheet to sheet to sheet, rather than grab the mouse and go click on the sheet you can very quickly using the keyboard use Ctrl page up or Ctrl page down.
Now another interesting thing is that if you get so many worksheets that it's hard to navigate through.
These set of four controls over here.
If you would right click It actually pops up a list of all the different controls and if we would have so many sheets let me use Shift F 11 to add a whole bunch of new sheets that there's more than what can be shown when you right-click you might get the more sheets icon which actually pops up a brand new activate dialog where you can get a list of all the sheets and again, we get to that by right-clicking the set of four controls on the left hand side but again fast way to move from sheet to sheet to sheet Ctrl page up Ctrl page down.
Much faster than using the mouse.
Hey, thanks for stopping by. We'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

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