I got a fever. And the prescription is more keyboard.
Power-users of Excel on Wall Street and in consulting firms try to minimize their use of the mouse. One of the myths about Excel for Mac, and Macs in general, is that you need to use a mouse. This is not true. In this post, we’ll share a tip on how to navigate contextual menus in Excel for Mac using only the keyboard.
Step 1: Open System Preferences and select the Keyboard menu. On the bottom left, switch Full Keyboard Access to “All Controls.” Close out of the window and open Excel.
Step 2: Execute the Format Cells shortcut:
This opens up the formatting cells menu.
Step 3: Hit the tab key.
This will highlight the clickable objects in the Format Cells dialog box. You can use the arrow keys to move within the top navigation bar. Another click of Tab brings you to the Category list where you once again can use the arrows to navigate through the list. To choose an option move to the category you wish to choose and hit Tab again. This will bring you to the options inside the window.
If you want to select a check box, use the space bar. (Hitting enter will click OK and exit the menu)
You can use tab to cycle back up to the top menu where you can again use arrow keys to move the selection. Hit the space bar to open up a new section. Repeat as necessary until you want to return to your workbook. Hit Enter.
Practice using the keyboard more and you’ll be much more efficient and proficient in Excel for Mac.
Comments will be approved before showing up.