In case you can’t change the order of the sheets and still want to switch between two sheets that are far off (say sheets 1 and 8), you can right-click in the area between the sheet navigator arrows (as shown below), and it will open the Activate dialog box where you can double-click in the sheet to which you want to go. Alternative to Keyboard Shortcut to Switch Between Tabs 6 Excel Shortcuts for PC and Mac 7 Editing Shortcuts 8 Formatting Shortcuts 9 Navigation Shortcuts 10 File Shortcuts 10 Ribbon Shortcuts 10 Paste Special Shortcuts. If the two tabs are far apart, while you can still use the keyboard shortcut, it would take longer. This method is well suited in situations where you have the sheets/tabs (between which you want to switch) either next to each other or close.

If you want to go two sheets before, hold the Control key and then press the PageUp key twice. If you keep holding the PageDown key, it will keep moving through the sheets and take you to the end.Īnd the same goes for the PageUp key (you only need to press it once to go to one sheet before). Note that when you hold the Control key and press the PageDown key once, it will only switch to the next sheet/tab. To use these above keyboard shortcuts, you need to Click off 'Enable Auto-Complete for cell values. Disable Autocomplete Open Excel settings/preferences. Under 'Calculation options,' (under the 'Formulas' tab in Windows), chose 'Automatic except for data tables' and click on 'Enable iterative calculation.' 2. To go to the previous worksheet/tab Control + PageUp How to Use the Keyboard Shortcut to Switch Between Tabs/Worksheets Open Excel settings/preferences (Alt T O on Windows, Ctrl +, on Mac). To go to the next worksheet/tab: Control + PageDown

But remember something: While it sounds nice to know. Shortcut to Switch Between Sheets in Excelīelow is the keyboard shortcut to switch sheets/tabs in Excel So, if you are looking for something like an Excel shortcuts cheat sheet, there is no better place than the official Microsoft support page. Alternative to Keyboard Shortcut to Switch Between Tabs.

How to Use the Keyboard Shortcut to Switch Between Tabs/Worksheets.

Shortcut to Switch Between Sheets in Excel.

Cheat sheet excel shortcuts