MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Next Worksheet

August 04, 2017 - by Bill Jelen

Excel Shortcuts - Next Worksheet

How to jump to the next (or previous) worksheet in Excel. This is the next in our series of keyboard shortcut tricks for Excel.

If you need to move from Sheet1 to Sheet5, press Ctrl + PageDown four times. If you are at Sheet9 and need to move to Sheet3, press Ctrl + PageUp six times. Thanks to Jeneta Hot.

Watch Video

Video Transcript

Learn Excel From MrExcel, Episode 2124: CONTROL+PAGEUP And CONTROL+PAGEDOWN.

Alright. If you have a bunch of worksheets like I have here and you need to jump from one worksheet to another, CONTROL+PAGEUP will move to the left, so I can go left, left, left, or if I'm here and I need to go to the right, CONTROL+PAGEDOWN will move to the right.

CONTROL+PAGEUP, CONTROL+PAGEDOWN. Awesome, awesome little keyboard shortcuts.

Hey. I want to thank you for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: klimkin / Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.