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:
You can Download in PDF
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 |
No comments:
Post a Comment