Saturday, March 25, 2017

Excel keyboard shortcuts

To do this Press
Open the Tell me box on the Ribbon and type a search term for assistance or Help content. Alt+Q, and then enter the search term.
Open the File page and use Backstage view. Alt+F
Open the Home tab and format text and numbers and use the Find tool. Alt+H
Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Alt+N
Open the Page Layout tab and work with themes, page setup, scale, and alignment. Alt+P
Open the Formulas tab and insert, trace, and customize functions and calculations. Alt+M
Open the Data tab and connect to, sort, filter, analyze, and work with data. Alt+A
Open the Review tab and check spelling, add comments, and protect sheets and workbooks. Alt+R
Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Alt+W
Work in the ribbon with the keyboard  
To do this Press
Select the active tab of the ribbon, and activate the access keys. Alt or F10. To move to a different tab, use access keys or the arrow keys.
Move the focus to commands on the ribbon. Tab or Shift+Tab
Move down, up, left, or right, respectively, among the items on the Ribbon. The Down Arrow, Up Arrow, Left Arrow, or Right Arrow key
Activate a selected button. Spacebar or Enter
Open the list for a selected command. The Down Arrow key
Open the menu for a selected button. Alt+Down Arrow
When a menu or submenu is open, move to the next command. Down Arrow key
Expand or collapse the ribbon. Ctrl+F1
Open a context menu. Shift+F10
 
Or, on a Windows keyboard
 
Context key (between the right Alt and right Ctrl keys)
Move to the submenu when a main menu is open or selected. Left Arrow key