< Back

Excel:Ribbon shortcuts

Tue Oct 16, 2018 8:59 am

Keyboard access to the ribbon



If you're new to the Ribbon, you can user this option to help you understand the Ribbon's keyboard shortcut model. The Ribbon comes with shortcuts called Key Tips, which you can make appear when you press the Alt key.

To display a tab on the Ribbon, press the key for the tab???for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab's buttons appear, as shown in the following image. Then, press the key for the button you want.



Image



Here in this example once you kit N for the Insert tab you would be presented with the shortcuts for the items under the insert tab.



Image



Using shortcut Alt- N - V would insert a Pivot table in your sheet