Excel Shortcut Guide 2024: Quickly Move Between Tabs

Navigating through multiple tabs in Excel can be a bit of a headache, especially when you’re dealing with a large spreadsheet. But don’t worry, there’s a shortcut that can make your life a whole lot easier. By simply using a combination of keys on your keyboard, you can move between tabs without having to click through each one. It’s quick, efficient, and a real time-saver.

Step by Step Tutorial: How to Use the Excel Shortcut to Move Between Tabs

Before we dive into the steps, it’s important to know that this shortcut will help you switch from one tab to another in a snap. It’s a simple key combination that you’ll wonder how you ever lived without.

Step 1: Press and hold the ‘Ctrl’ key

Hold down the ‘Ctrl’ key on your keyboard. This key is usually located in the bottom left corner of your keyboard.

The ‘Ctrl’ key is like the magic wand of keyboard shortcuts. It’s the key that, when combined with others, can make all sorts of tasks much easier.

Step 2: Press the ‘Page Up’ or ‘Page Down’ key

While holding the ‘Ctrl’ key, press either the ‘Page Up’ key to move to the previous tab or the ‘Page Down’ key to move to the next tab.

The ‘Page Up’ and ‘Page Down’ keys are usually located near the ‘Home’ and ‘End’ keys on your keyboard. They might also have arrows pointing up and down.

After completing these steps, you’ll find yourself on the next or previous tab in your Excel workbook. It’s a seamless transition that doesn’t disrupt your workflow.

Tips for Using the Excel Shortcut to Move Between Tabs

  • Make sure you’re holding down the ‘Ctrl’ key before pressing ‘Page Up’ or ‘Page Down’.
  • This shortcut only works if you have multiple tabs open in your Excel workbook.
  • If you press the ‘Page Up’ key on the first tab, it won’t move to the last tab. Similarly, if you press ‘Page Down’ on the last tab, it won’t loop back to the first tab.
  • Practice using this shortcut to become faster and more efficient at navigating through your Excel workbooks.
  • Customize your keyboard shortcuts in Excel if you prefer a different key combination for moving between tabs.

Frequently Asked Questions

Can I use this shortcut on a Mac?

Yes, the shortcut works on a Mac as well. Instead of the ‘Ctrl’ key, you’ll use the ‘Command’ key along with ‘Page Up’ or ‘Page Down’.

What if my keyboard doesn’t have ‘Page Up’ or ‘Page Down’ keys?

Some smaller keyboards, like those on laptops, might not have these keys. In that case, you can usually use ‘Fn’ + ‘Up Arrow’ for ‘Page Up’ and ‘Fn’ + ‘Down Arrow’ for ‘Page Down’.

Will this shortcut work in other spreadsheet programs?

While this shortcut is specific to Excel, other spreadsheet programs like Google Sheets have similar shortcuts for moving between tabs.

Can I move to a specific tab with a shortcut?

No, this shortcut only moves to the next or previous tab. To move to a specific tab, you will still need to click on the tab with your mouse or use a custom macro.

Does this shortcut work in all versions of Excel?

Yes, this shortcut has been a part of Excel for many versions and should work in any modern version of Excel.


  1. Press and hold ‘Ctrl’
  2. Press ‘Page Up’ or ‘Page Down’


Mastering the art of Excel shortcuts can truly elevate your spreadsheet game. By utilizing the simple yet highly effective combination of ‘Ctrl’ + ‘Page Up/Page Down’, you can swiftly navigate between tabs, saving you precious time and keeping your focus intact. Whether you’re a seasoned Excel pro or just getting started, this shortcut is a must-have in your toolkit. After all, efficiency is key in any work you do, and this little trick certainly delivers.

Imagine all the extra time you’ll have on your hands once you start using this shortcut regularly. You could use those extra minutes to double-check your work, take a quick break, or even learn another handy Excel shortcut. The possibilities are endless, and it all starts with the push of a couple of buttons. So go ahead, give it a try and watch your productivity soar. Happy tabbing, Excel enthusiasts!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy