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
Microsoft Excel 2019 Inside Out

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.