Cycling through Excel sheets seems like a shortcut that should be taught at the same time as copy and paste, but it unfortunately is not for most. I can’t think of anything more frustrating than having one Excel document open with multiple sheets in there and having to stop what you are doing to use the mouse and click on another sheet. Here’s how to cycle through your sheets a whole lot faster.
Step 1: This shortcut obviously needs multiple sheets in 1 Excel document. If you are not familiar with using multiple sheets they can be found on the bottom left of your Excel document. You can add or subtract sheets based on your needs but the default Microsoft Excel spreadsheet has 3 blank sheets. They can be renamed as well. For this shortcut I will stick with Sheet 1, Sheet 2, Sheet 3.
Step 2: Execute the shortcut. This shortcut will allow you to move right or left, depending on the arrow keys used. Note: it will only cycle sheets in a linear fashion, it does not loop from last to first and first to last.
Cycle to the right:
⌥ right arrow
Cycle to the left:
⌥ left arrow
One click of the shortcut with the right arrow lands us on Sheet2:
Another click with the right will go to Sheet3, and then we can utilize the left arrow and move back to Sheet2 and Sheet1.
This is the fastest and easiest way to cycle through sheets in a single Microsoft Excel spreadsheet. Enjoy the vacation away from your mouse!
Comments will be approved before showing up.