Subscribe for New Post Notifications

Ribbon keyboard shortcuts

If you are the new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model.

When you press the Alt key, letters appear in small images, called key tips, next to tabs and commands on the ribbon.

You can combine these letters with Alt to make shortcuts called Access keys for ribbon commands. For ex. Alt+H opens the Home tab.

Access keys for ribbon tabs

To go directly to a tab on the ribbon, press one of the following access keys:

Excel Shortcut To do this
Alt + F Open the File page and use backstage view
Alt + H Open the Home tab and format text and numbers and use the find tool
Alt + N Open the Insert tab and insert PivotTables, Charts, Add-ins, Pictures
Alt + P Open the Page layout tab and work with themes, Page setup, Scale and Alignment
Alt + M Open the Formulas tab and inserts customize functions and calculations
Alt + A Open the Data tab and connect to, sort, filter, analyze and work with data
Alt + R Open the Review tab and check spelling , Add comments and Protect sheets and workbook
Alt + W 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

You can Download in PDF

No comments:

Post a Comment