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 move or copy data between sheets. 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. Use the keyboard shortcut CTRL + SHIFT + PAGE UP or CTRL + SHIFT + PAGE DOWN Simply press CTRL + TAB to move to the next sheet, or CTRL + SHIFT + TAB to move to the previous sheet.

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. This is probably the most intuitive way to move between sheets, and it's also very fast once you get used to it. Use the sheet tabsĪnother quick and easy way to move between sheets is to simply click on the sheet tabs at the bottom of the Excel window. You can also hold down the CTRL key and use the mouse scroll wheel to move between sheets. Simply press CTRL + PAGE UP to move to the previous sheet, or CTRL + PAGE DOWN to move to the next sheet. These keyboard shortcuts are probably the quickest and easiest way to move between sheets in Excel. Use the keyboard shortcuts CTRL + PAGE UP and CTRL + PAGE DOWN Fortunately, there are a few simple shortcuts that can help you move between sheets more quickly and efficiently.

Otherwise, you can waste a lot of time scrolling through sheets that are not relevant to the task at hand.

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.

Windows 7 excel shortcut keys