Look Who it Was Random video

Excel - Fast and Easy Way to Navigate Between Worksheets in Excel - Episode 608

273 views · Published 7 April 2009 · 1:59 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Fast and Easy Way to Navigate Between Worksheets in Excel.

Welcome back to the MrExcel Netcast! In this video, I'll be sharing a quick tip that many people have asked me about during my seminars. Have you ever wondered how I navigate through multiple worksheets so quickly? Well, the trick is to use the keyboard shortcuts Ctrl + Page Up and Ctrl + Page Down. This allows you to move to the left or right of your sheets without having to use the mouse.

But what if you have so many worksheets that it becomes difficult to navigate through them? Don't worry, there's a solution for that too. If you right-click on the set of four controls on the left-hand side, a list of all the worksheets will pop up. And if you have even more sheets than what can be shown, you can use the Shift + F11 shortcut to add new sheets and then access them through the "More Sheets" icon in the list.

Using these shortcuts not only saves you time, but it also makes your work more efficient. No more clicking on each sheet with your mouse, simply use the keyboard shortcuts and you'll be flying through your worksheets in no time. And if you ever need a quick overview of all your sheets, just right-click on the controls and access the "Activate" dialog to see a list of all your sheets.

I hope you found this tip helpful and that it will make your Excel experience even better. Thanks for watching and don't forget to subscribe to our channel for more useful tips and tricks. See you next time for another netcast 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/

Table of Contents:
(00:00) Introduction 
 
(00:20) Flying between sheets 
(00:39) Using Ctrl key and page up/down 
(00:49) Jumping between sheets 
(01:00) Navigating through many sheets 
(01:10) Right-click for more options 
(01:22) "More Sheets" icon 
(01:39) 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:
Ctrl page up and Ctrl page down shortcut
Efficient sheet navigation in Excel
Excel worksheet navigation tricks
Fast navigation in Excel
How to fly through Excel sheets
Keyboard shortcuts in Excel
More sheets icon in Excel
Moving between Excel worksheets
Navigating through multiple worksheets
Right-click controls for sheet navigation
Using Ctrl key for quick sheet switching
YouTube video tips

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152339/



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!

More from this channel