Messing around with multiple workbooks in Microsoft Excel for Mac can sometimes be a pain. I am stuck in the bad habit of pressing “command” + “tab” to cycle through applications in hopes that it will cycle through my MS Excel worksheets but that’s not how it works. The Excel Skin maps out “command” + “tab” = “Cycle thru: Applications” but if we take a second to inspect our “tab” key we can see it also has an option to cycle through workbooks. Excellent! Now lets put this tab key to work.
Step 1: The only prerequisite to performing this shortcut is to have two or more workbooks open and at least one active at the time you execute the shortcut. More simply you need multiple workbooks and MS Excel has to be the active application.
Step 2: Execute the shortcut. This shortcut resides on the “tab” key and in yellow text. Taking a look at our modifier keys we can see there is only one modifier key that has the corresponding yellow text. Therefore our shortcut is:
Step 3: Executing the shortcut will switch from the active workbook to the next. If you have only two workbooks open this shortcut will keep switching back and forth between the two. If there are more than two workbooks open it will cycle from the first to the last workbook, and then back to the first in a loop.
This is extremely useful when working with multiple workbooks. The time it takes to drag one workbook over so you can see the other one is ridiculous. The “Cycle Thru: Workbooks” shortcut is the only efficient way of switching back and forth between workbooks.
Although I am still stuck in the bad habit of “command” + “tab”, which just switches applications and wastes more time, my goal of the week is to make the “control” + “tab” shortcut embedded in the Excel side of my brain.
Comments will be approved before showing up.