Excel keyboard shortcuts

This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands. If you’re using a Mac, please see Excel keyboard shortcuts and function keys for Mac.

IMPORTANT:

  • 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 (,).
2016 2013 2010 2007

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.

TIPS:

  • 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
Copy Ctrl+C
Paste Ctrl+V
Undo Ctrl+Z
Remove cell contents Delete key
Choose a fill color Alt+H, H
Cut Ctrl+X
Go to Insert tab Alt+N
Bold Ctrl+B
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

Context key

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

Ctrl+0