Excel shortcuts

19 Shortcuts for Navigating Tabs in Excel

If you work with Microsoft Excel on a regular basis, you know that it can be quite tedious to have to constantly click back and forth between different tabs. Luckily, there are a few shortcuts that can help you quickly navigate between tabs without having to take your hands off the keyboard.

1. Ctrl + Page Up/Page Down: This shortcut will take you to the previous or next tab in your workbook. If you're on the first tab and you press Ctrl + Page Up, you'll be taken to the last tab. Similarly, if you're on the last tab and you press Ctrl + Page Down, you'll be taken to the first tab.

2. Ctrl + Tab: This shortcut behaves similarly to the Ctrl + Page Up/Page Down shortcut, but it only takes you to the next tab. So, if you're on the first tab and you press Ctrl + Tab, you'll be taken to the second tab. If you're on the last tab and you press Ctrl + Tab, you'll be taken to the first tab.

3. Ctrl + Shift + Tab: This shortcut behaves similarly to the Ctrl + Tab shortcut, but it only takes you to the previous tab. So, if you're on the first tab and you press Ctrl + Shift + Tab, you'll be taken to the last tab. If you're on the last tab and you press Ctrl + Shift + Tab, you'll be taken to the first tab.

4. Ctrl + Left Arrow/Right Arrow: This shortcut will take you to the tab to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Right Arrow, you'll be taken to the second tab. Similarly, if you're on the last tab and you press Ctrl + Left Arrow, you'll be taken to the second to last tab.

5. Ctrl + Shift + Left Arrow/Right Arrow: This shortcut behaves similarly to the Ctrl + Left Arrow/Right Arrow shortcut, but it only takes you to the tab to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + Right Arrow, you'll be taken to the last tab. Similarly, if you're on the last tab and you press Ctrl + Shift + Left Arrow, you'll be taken to the first tab.

6. Ctrl + Home/End: This shortcut will take you to the first or last tab in your workbook. So, if you're on the first tab and you press Ctrl + End, you'll be taken to the last tab. Similarly, if you're on the last tab and you press Ctrl + Home, you'll be taken to the first tab.

7. Ctrl + Shift + Home/End: This shortcut behaves similarly to the Ctrl + Home/End shortcut, but it only takes you to the tab to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + End, you'll be taken to the last tab. Similarly, if you're on the last tab and you press Ctrl + Shift + Home, you'll be taken to the first tab.

8. Ctrl + Click: If you want to quickly select multiple tabs, you can use the Ctrl + Click shortcut. Simply hold down the Ctrl key and click on the tabs you want to select. Once you've selected the tabs you want, you can let go of the Ctrl key and continue working with your selected tabs.

9. Ctrl + A: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + A and all 10 tabs will be selected.

10. Ctrl + Shift + A: This shortcut behaves similarly to the Ctrl + A shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + A, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + A, all tabs to the left of the last tab will be selected.

11. Ctrl + B: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + B and all 10 tabs will be selected.

12. Ctrl + Shift + B: This shortcut behaves similarly to the Ctrl + B shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + B, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + B, all tabs to the left of the last tab will be selected.

13. Ctrl + C: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + C and all 10 tabs will be selected.

14. Ctrl + Shift + C: This shortcut behaves similarly to the Ctrl + C shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + C, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + C, all tabs to the left of the last tab will be selected.

15. Ctrl + D: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + D and all 10 tabs will be selected.

16. Ctrl + Shift + D: This shortcut behaves similarly to the Ctrl + D shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + D, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + D, all tabs to the left of the last tab will be selected.

17. Ctrl + E: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + E and all 10 tabs will be selected.

18. Ctrl + Shift + E: This shortcut behaves similarly to the Ctrl + E shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + E, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + E, all tabs to the left of the last tab will be selected.

19. Ctrl + F: This shortcut allows you to quickly select all tabs in your workbook. So, if you have a workbook with 10 tabs and you want to select them all, you can press Ctrl + F and all 10 tabs will be selected.

20. Ctrl + Shift + F: This shortcut behaves similarly to the Ctrl + F shortcut, but it only selects the tabs to the left or right of the current tab. So, if you're on the first tab and you press Ctrl + Shift + F, all tabs to the right of the first tab will be selected. Similarly, if you're on the last tab and you press Ctrl + Shift + F, all tabs to the left of the last tab will be selected.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.