Excel shortcuts

15 Excel Shortcuts for Switching Sheets

If you're anything like me, you're always looking for ways to work faster and more efficiently in Excel. One of the things that can really slow you down when working in a large workbook is having to constantly switch between sheets. Thankfully, there are a few shortcuts that can help you quickly switch between sheets in Excel.

1. Ctrl + Page Up/Page Down - This shortcut will move you to the previous or next sheet in your workbook. This is a great shortcut if you have a lot of sheets and need to move back and forth between them quickly.

2. Ctrl + Tab - This shortcut will open up the workbook tabs so you can quickly select the sheet you want to switch to. This is especially helpful if you have a lot of sheets and the sheet you want is not next to the one you're currently on.

3. Ctrl + Shift + Tab - This shortcut does the same thing as the Ctrl + Tab shortcut, but in reverse. So, if you're on the last sheet in your workbook and want to quickly switch to the first sheet, this shortcut will do that for you.

4. F5 - This shortcut will bring up the Go To dialog box. From here, you can type in the name of the sheet you want to switch to and Excel will take you there.

5. Ctrl + click on a sheet tab - This shortcut will allow you to quickly select multiple sheets. This can be helpful if you need to move or delete multiple sheets at once.

6. Double-click on a sheet tab - This shortcut will rename the sheet you double-click on. This can be helpful if you want to quickly change the name of a sheet without having to go into the sheet tab's properties.

7. Right-click on a sheet tab - This shortcut will bring up a menu of options for the sheet you right-click on. This menu includes options for moving, copying, deleting, and renaming the sheet.

8. Shift + F11 - This shortcut will insert a new sheet into your workbook. This is a great shortcut to use if you're working on a large project and need to add new sheets frequently.

9. Ctrl + Shift + F11 - This shortcut will insert a new sheet into your workbook and place it before the sheet you're currently on. This can be helpful if you want to keep your sheets organized in a certain order.

10. Alt + Shift + F11 - This shortcut will insert a new sheet into your workbook and place it after the sheet you're currently on. This can be helpful if you want to keep your sheets organized in a certain order.

11. Ctrl + F11 - This shortcut will create a new workbook. This can be helpful if you're working on multiple projects at the same time and need to have a separate workbook for each one.

12. Ctrl + N - This shortcut will create a new workbook in the same window as the one you're currently working in. This can be helpful if you want to quickly create a new workbook without having to open a new window.

13. Ctrl + W - This shortcut will close the workbook you're currently working in. This can be helpful if you're finished working on a project and want to close the workbook quickly.

14. Ctrl + Shift + W - This shortcut will close all open workbooks. This can be helpful if you're finished working for the day and want to close all of your open workbooks quickly.

15. Ctrl + F4 - This shortcut will close the workbook you're currently working in. This can be helpful if you want to close the workbook quickly and don't want to save any changes you've made.

I hope you found these shortcuts helpful! If you have any other shortcuts that you use to quickly switch between sheets in Excel, please share them in the comments below.

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.