Excel shortcuts

The best shortcuts to quickly move between sheets in Excel

If you work with large Excel spreadsheets on a regular basis, you know how important it is to be able to move quickly between sheets. Otherwise, you can waste a lot of time scrolling through sheets that are not relevant to the task at hand. Fortunately, there are a few simple shortcuts that can help you move between sheets more quickly and efficiently.

1. Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN

These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet. You can also hold down the CTRL key and use the mouse scroll wheel to move between sheets.

2. Use the sheet tabs

Another quick and easy way to move between sheets is to simply click on the sheet tabs at the bottom of the Excel window. This is probably the most intuitive way to move between sheets, and it's also very fast once you get used to it.

3. Use the keyboard shortcut CTRL + TAB

This keyboard shortcut works similarly to the previous two, but it has the added benefit of allowing you to move between sheets in both directions. Simply press CTRL + TAB to move to the next sheet, or CTRL + SHIFT + TAB to move to the previous sheet.

4. Use the keyboard shortcut CTRL + SHIFT + PAGE UP or CTRL + SHIFT + PAGE DOWN

These keyboard shortcuts work just like the regular PAGE UP and PAGE DOWN shortcuts, but they also allow you to select multiple sheets at the same time. This can be very useful if you need to move or copy data between sheets.

5. Use the keyboard shortcut ALT + F11

This keyboard shortcut opens the Excel VBA editor, which allows you to view and edit the code for your Excel macros. This can be very useful if you need to make changes to a macro that is located on a different sheet.

6. Use the keyboard shortcut CTRL + SHIFT + O

This keyboard shortcut opens the "Select Objects" dialog box, which allows you to select multiple objects on a sheet. This can be very useful if you need to move or delete multiple objects at the same time.

7. Use the keyboard shortcut CTRL + SHIFT + FThis keyboard shortcut opens the "Find and Replace" dialog box, which allows you to quickly find and replace text in your Excel spreadsheet. This can be very useful if you need to make changes to a large number of cells at the same time.

8. Use the keyboard shortcut CTRL + SHIFT + H

This keyboard shortcut opens the "Replace" dialog box, which allows you to quickly find and replace text in your Excel spreadsheet. This can be very useful if you need to make changes to a large number of cells at the same time.

9. Use the keyboard shortcut CTRL + SHIFT + J

This keyboard shortcut opens the "Go To" dialog box, which allows you to quickly jump to a specific cell in your Excel spreadsheet. This can be very useful if you need to make changes to a large number of cells at the same time.

10. Use the keyboard shortcut CTRL + SHIFT + K

This keyboard shortcut opens the "Insert" dialog box, which allows you to quickly insert a new sheet into your Excel workbook. This can be very useful if you need to add a new sheet to your workbook on a regular basis.

Bonus tip: Use the keyboard shortcut CTRL + SHIFT + L

This keyboard shortcut opens the "Filter" dialog box, which allows you to quickly filter your data by various criteria. This can be very useful if you need to analyze a large amount of data on a regular basis.

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.