- These shortcuts refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
- If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). If you have to press one key immediately after another, the keys are separated by a comma (,).
This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Excel 2016. This includes the access keys that you can use for ribbon commands. For Excel Online, see Keyboard shortcuts in Excel Online.
- To keep this reference available when you work, you may want to print this topic. To print this topic, press CTRL+P.
- To see an online workbook with this information, check out our spreadsheet on Docs.com. This workbook lets you scroll, sort, and filter for any key combination. And, you can also download it.
- Get these keyboard shortcuts in a Word document at this link: Excel 2016 for Windows keyboard shortcuts
Frequently used shortcuts
If you’re new to the Ribbon, the information in this section can help you understand the Ribbon’s keyboard shortcut model. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. The Ribbon groups related commands on tabs. For example, on the Home tab, the Number group includes the Number Format command.
This table lists the most frequently used shortcuts in Excel 2016.
|To do this||Press|
|Close a spreadsheet||Ctrl+W|
|Open a spreadsheet||Ctrl+O|
|Go to the Home tab||Alt+H|
|Save a spreadsheet||Ctrl+S|
|Remove cell contents||Delete key|
|Choose a fill color||Alt+H, H|
|Go to Insert tab||Alt+N|
|Center align cell contents||Alt+H, A, then C|
|Go to Page Layout tab||Alt+P|
|Go to Data tab||Alt+A|
|Go to View tab||Alt+W|
|Open context menu||Shift+F10, or
|Add borders||Alt+H, B|
|Delete column||Alt+H,D, then C|
|Go to Formula tab||Alt+M|
|Hide the selected rows||Ctrl+9|
|Hide the selected columns||