Tip: To cancel the action you’re taking and hide the KeyTips, press and release the ALT key. Keyboard shortcuts for KeyTips The keyboard shortcuts in the following table can be used to activate the KeyTips described in the previous section. To do this Press Open the File page. Alt+F Open the Home tab.
224 Excel keyboard shortcuts for Windows and Mac. The keyboard shortcuts make your work easier, faster and more efficiently. This list covers 224 shortcut keys you can use for Windows and Mac. It’s organized by 13 categories which you experience in Excel 2016. Display [View] tab in ribbon: Alt.
Alt+H Open the Insert tab. Alt+N Open the Design tab.
Alt+G Open the Transitions tab. Alt+T Open the Animations tab. Alt+A Open the Slide Show tab. Alt+S Open the Review tab.
Alt+R Open the View tab. Alt+W Open the Tell me box. Alt+Q, and then enter the search term Change the keyboard focus without using the mouse Another way to use the keyboard to work with the ribbon is to move the focus among the tabs and commands until you find the feature you want to use. The following shows some ways to move the keyboard focus without using the mouse. To do this Press Select the active tab and show the access keys.
Press either of these keys again to move back to the Office file and cancel the access keys. Move to another tab. ALT or F10 to select the active tab, and then LEFT ARROW or RIGHT ARROW.
Move to another Group on the active tab. ALT or F10 to select the active tab, and then CTRL+RIGHT ARROW or LEFT ARROW to move between groups. Minimize (collapse) or restore the ribbon. CTRL+F1 Display the shortcut menu for the selected item. SHIFT+F10 Move the focus to select the active tab, your Office file, task pane, or status bar.
F6 Move the focus to each command in the ribbon, forward or backward. ALT or F10, and then TAB or SHIFT+TAB Move down, up, left, or right among the items in the ribbon. DOWN ARROW, UP ARROW, LEFT ARROW, or RIGHT ARROW Go to the selected command or control in the ribbon.
SPACE BAR or ENTER Open the selected menu or gallery in the ribbon. SPACE BAR or ENTER Go to a command or option in the ribbon so you can change it. ENTER Finish changing the value of a command or option in the ribbon, and move focus back to the Office file. ENTER Get help on the selected command or control in the ribbon.
(If no Help article is associated with the selected command, the Help table of contents for that program is shown instead.) F1.
Tip: To cancel the action you’re taking and hide the KeyTips, press and release the ALT key. Keyboard shortcuts for KeyTips The keyboard shortcuts in the following table can be used to activate the KeyTips described in the previous section. To do this Press Open the File page.
Alt+F Open the Home tab. Alt+H Open the Insert tab. Alt+N Open the Design tab. Alt+G Open the Transitions tab. Alt+T Open the Animations tab. Alt+A Open the Slide Show tab.
Alt+S Open the Review tab. Alt+R Open the View tab. Alt+W Open the Tell me box. Alt+Q, and then enter the search term Change the keyboard focus without using the mouse Another way to use the keyboard to work with the ribbon is to move the focus among the tabs and commands until you find the feature you want to use. The following shows some ways to move the keyboard focus without using the mouse. To do this Press Select the active tab and show the access keys. Press either of these keys again to move back to the Office file and cancel the access keys.
Move to another tab. ALT or F10 to select the active tab, and then LEFT ARROW or RIGHT ARROW. Move to another Group on the active tab.
ALT or F10 to select the active tab, and then CTRL+RIGHT ARROW or LEFT ARROW to move between groups. Minimize (collapse) or restore the ribbon. CTRL+F1 Display the shortcut menu for the selected item. SHIFT+F10 Move the focus to select the active tab, your Office file, task pane, or status bar. F6 Move the focus to each command in the ribbon, forward or backward. ALT or F10, and then TAB or SHIFT+TAB Move down, up, left, or right among the items in the ribbon. DOWN ARROW, UP ARROW, LEFT ARROW, or RIGHT ARROW Go to the selected command or control in the ribbon.
SPACE BAR or ENTER Open the selected menu or gallery in the ribbon. SPACE BAR or ENTER Go to a command or option in the ribbon so you can change it. ENTER Finish changing the value of a command or option in the ribbon, and move focus back to the Office file. ENTER Get help on the selected command or control in the ribbon. (If no Help article is associated with the selected command, the Help table of contents for that program is shown instead.) F1.