Show hotkeys in excel
With the Control key down + you can use the right an left arrow to move through groups. Then move through commands using tab and shift tab. Once you have a tab on the ribbon selected, you can use tab key to select the first command.
Show hotkeys in excel windows#
These commands don't have dedicated shortcuts in the Windows version of Excel Note that once you have a tab selected, you can also use the arrow keys to navigate.Īs another example, I'll use accelerators to apply Right, Left, and Center alignment. Then, if I press Escape, I'll move the top level letters again and can press A to go back to the Data tab. For example, Alt + H goes to the home tab. You can use the Esc key to move back up to the top level. To sort in descending order, I use Alt + A + SD.
You can use accelerators to navigate tabs, and then run a command, all in one step.įor example, to sort this list in ascending order, I can press Alt, then A for Data, then SA. Press the Alt key again to disable accelerators, and set focus to the worksheet. This will select the active tab on the Ribbon and display accelerators for navigation. To enable accelerators, press the Alt key. Unfortunately, this is a Windows-only feature, so it's not available on a Mac. The main attraction of the ribbon, from a shortcuts point of view, is accelerator keys.Īccelerator keys let you run most commands in Excel from the keyboard, which is especially handy for commands that don't have a dedicated shortcut. Each time you use the shortcut, you'll toggle the ribbon. In this video, we'll look at shortcuts that let you work with the Ribbon.įirst, because the Ribbon takes up quite a lot of space, you may want to collapse it when you don't need it.