Frequently used shortcuts
This table lists the most frequently used shortcuts in Excel.
| To do this | Press |
| Close a workbook. | Ctrl+W |
| Open a workbook. | Ctrl+O |
| Go to the Home tab. | Alt+H |
| Save a workbook. | Ctrl+S |
| Copy selection. | Ctrl+C |
| Paste selection. | Ctrl+V |
| Undo recent action. | Ctrl+Z |
| Remove cell contents. | Delete |
| Choose a fill color. | Alt+H, H |
| Cut selection. | Ctrl+X |
| Go to the Insert tab. | Alt+N |
| Apply bold formatting. | Ctrl+B |
| Center align cell contents. | Alt+H, A, C |
| Go to the Page Layout tab. | Alt+P |
| Go to the Data tab. | Alt+A |
| Go to the View tab. | Alt+W |
| Open the context menu. | Shift+F10 or Windows Menu key |
| Add borders. | Alt+H, B |
| Delete column. | Alt+H, D, C |
| Go to the Formula tab. | Alt+M |
| Hide the selected rows. | Ctrl+9 |
| Hide the selected columns. | Ctrl+0 |
Ribbon keyboard shortcuts
The ribbon groups related options on tabs. For example, on the Home tab, the Number group includes the Number Format option. Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below.
| To do this | Press |
| Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content. | Alt+Q, then enter the search term. |
| Open the File menu. | Alt+F |
| Open the Home tab and format text and numbers and use the Find tool. | Alt+H |
| Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. | Alt+N |
| Open the Page Layout tab and work with themes, page setup, scale, and alignment. | Alt+P |
| Open the Formulas tab and insert, trace, and customize functions and calculations. | Alt+M |
| Open the Data tab and connect to, sort, filter, analyze, and work with data. | Alt+A |
| Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks. | Alt+R |
| 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. | Alt+W |