Shortcut key | Description | RANK |
Ctrl+W | Close a workbook. | 1 |
Ctrl+O | Open a workbook. | 1 |
Ctrl+S | Save a workbook. | 1 |
Ctrl+C | Copy selection. | 1 |
Ctrl+V | Paste selection. | 1 |
Ctrl+Z | Undo recent action. | 1 |
Delete | Remove cell contents. | 1 |
Ctrl+X | Cut selection. | 1 |
Ctrl+B | Apply bold formatting. | 1 |
Shift+F10 | Open the context menu/orWindows Menu key | 1 |
Alt+H, B | Add borders. | 1 |
Alt+H, D, C | Delete column. | 1 |
Ctrl+9 | Hide the selected rows. | 1 |
Ctrl+0 | Hide the selected columns. | 1 |
Ctrl+F1 | Expand or collapse the ribbon. | 1 |
Shift+Tab | Move to the previous cell in a worksheet or the previous option in a dialog box. | 1 |
Page up | Move one screen up in a worksheet. | 1 |
Ctrl+1 | Open the Format Cells dialog box. | 1 |
F2 | Edit cell | 1 |
Ctrl+Shift+Plus sign (+) | Open the Insert dialog box to insert blank cells. | 1 |
Ctrl+Minus sign (-) | Open the Delete dialog box to delete selected cells. | 1 |
Ctrl+Alt+V | Open the Paste Special dialog box. | 1 |
Ctrl+I or Ctrl+3 | Italicize text or remove italic formatting. | 1 |
Ctrl+B or Ctrl+2 | Bold text or remove bold formatting. | 1 |
Ctrl+U or Ctrl+4 | Underline text or remove underline. | 1 |
Ctrl+5 | Apply or remove strikethrough formatting. | 1 |
Ctrl+D | Use the Fill Down | 1 |
Ctrl+Shift+Dollar sign ($) | Apply the Currency format with two decimal places (negative numbers in parentheses). | 1 |
Ctrl+Shift+Percent sign (%) | Apply the Percentage format with no decimal places. | 1 |
Ctrl+Shift+Caret sign (^) | Apply the Scientific number format with two decimal places. | 1 |
Ctrl+Shift+Number sign (#) | Apply the Date format with the day, month, and year. | 1 |
Ctrl+Shift+At sign (@) | Apply the Time format with the hour and minute, and AM or PM. | 1 |
Ctrl+Shift+Exclamation point (!) | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. | 1 |
Ctrl+K | Open the Insert hyperlink dialog box. | 1 |
F7 | Check spelling in the active worksheet or selected range. | 1 |
Ctrl+L or Ctrl+T | Display the Create Table dialog box. | 1 |
Alt,E,S,A | Paste all cell contents and formatting. | 1 |
Alt,E,S,F | Paste only the formulas as entered in the formula bar. | 1 |
Alt,E,S,V | Paste only the values (not the formulas). | 1 |
Alt,E,S,T | Paste only the copied formatting. | 1 |
Alt,E,S,C | Paste only comments and notes attached to the cell. | 1 |
Alt,E,S,N | Paste only the data validation settings from copied cells. | 1 |
Alt,E,S,H | Paste all cell contents and formatting from copied cells. | 1 |
Alt,E,S,X | Paste all cell contents without borders. | 1 |
Alt,E,S,W | Paste only column widths from copied cells. | 1 |
Alt,E,S,R | Paste only formulas and number formats from copied cells. | 1 |
Alt,E,S,U | Paste only the values (not formulas) and number formats from copied cells. | 1 |
Ctrl+A or Ctrl+Shift+Spacebar | Select the entire worksheet. | 1 |
Ctrl+Shift+Page down | Select the current and next sheet in a workbook. | 1 |
Ctrl+Shift+Page up | Select the current and previous sheet in a workbook. | 1 |
Shift+Arrow key | Extend the selection of cells by one cell. | 1 |
Ctrl+Y | Repeat the last command or action, if possible. | 1 |
F9 | Calculate all worksheets in all open workbooks. | 1 |
Control+Shift+Equal sign ( = ) | Insert cells. | 1 |
Control+H | Display the Replace dialog box. | 1 |
Shift++Tab | Switch to the previous application. | 1 |
Control+G | Display the Go To dialog box. | 1 |
Control+E | Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column. | 1 |
Control+L | create Table | 1 |
Control+Semicolon (;) | Enter the date. | 1 |
Control+Shift+Tilde (~) | Apply the general number format. | 1 |
Control+Shift+Number sign (#) | Apply the date format with the day, month, and year. | 1 |
Control+Shift+At symbol (@) | Apply the time format with the hour and minute, and indicate AM or PM. | 1 |
Control+Shift+Exclamation point (!) | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values. | 1 |
Control+Hyphen | Delete the selection. | 1 |
Control+Shift+Left parenthesis (() | Unhide selected rows. | 1 |
Control+Shift+Right parenthesis ()) | Unhide selected columns. | 1 |
F12 | Display the Save As dialog box. | 1 |
Ctrl+P | Print a workbook. | 1 |
Alt+F2 | Open the Save As dialog box. | 1 |
Alt+Q | Jump to Search or Tell me. | 1 |
Ctrl+L | Insert a table. | 1 |
Ctrl+Shift+L | Toggle AutoFilter on and off. | 1 |
Ctrl+Shift+Apostrophe (') | Copy the value from the cell above. | 1 |
Ctrl+Shift+A | Insert a formula argument. | 1 |
Ctrl+Shift+1 | Apply the number format. | 1 |
Ctrl+Shift+2 | Apply the time format. | 1 |
Ctrl+Shift+3 | Apply the date format. | 1 |
Ctrl+Shift+4 | Apply the currency format. | 1 |
Ctrl+Shift+5 | Apply the percentage format. | 1 |
Ctrl+Shift+6 | Apply the scientific format. | 1 |
Ctrl+Shift+7 | Apply outside border. | 1 |
Ctrl+Plus sign (+) | Insert cells, rows, or columns. | 1 |
Ctrl+Shift+9 | Unhide rows. | 1 |
Ctrl+Shift+0 | Unhide columns | 1 |
Alt+F5 | Refresh external data. | 1 |
Alt+H, A, C | Center align cell contents. | 2 |
Down arrow key | Open the list for a selected command. | 2 |
Alt+Down arrow key | Open the menu for a selected button. | 2 |
Shift+F10 | Open a context menu. | 2 |
Ctrl+Page down | Move to the next sheet in a workbook. | 2 |
Alt+Page down | Move one screen to the right in a worksheet. | 2 |
Alt+Page up | Move one screen to the left in a worksheet. | 2 |
Ctrl+Page up | Move to the previous sheet in a workbook. | 2 |
Esc | Exit the floating shape navigation and return to the normal navigation. | 2 |
Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right | Scroll horizontally. | 2 |
Ctrl+Alt+Equal sign ( = ) | Zoom in. | 2 |
Ctrl+Alt+Minus sign (-) | Zoom out. | 2 |
Ctrl+Shift+Colon (:) | Enter the current time. | 2 |
Ctrl+Semicolon (;) | Enter the current date. | 2 |
Ctrl+Grave accent (`) | Switch between displaying cell values or formulas in the worksheet. | 2 |
Ctrl+Shift+G | Open the Workbook Statistics dialog box. | 2 |
F8 | Turn extend mode on and use the arrow keys to extend a selection. Press again to turn off. | 2 |
Shift+F8 | Add a non-adjacent cell or range to a selection of cells by using the arrow keys. | 2 |
Shift+Enter | Complete a cell entry and select the cell above. | 2 |
Ctrl+Spacebar | Select an entire column in a worksheet. | 2 |
Shift+Spacebar | Select an entire row in a worksheet. | 2 |
Ctrl+Shift+Spacebar | Select all objects on a worksheet when an object is selected. | 2 |
Ctrl+Shift+Asterisk sign (*) | Select the current region around the active cell. | 2 |
Alt+Equal sign ( = ) | Insert the AutoSum formula | 2 |
Ctrl+E | Invoke Flash Fill to automatically | 2 |
F4 | Recent Action | 2 |
Alt+F11 | Open the Microsoft Visual Basic For Applications Editor. | 2 |
Alt+F12 | Open the Power Query Editor | 2 |
Ctrl+F5 | Refresh data in the current worksheet. | 2 |
Ctrl+Alt+F5 | Refresh all data in the workbook. | 2 |
Ctrl+A | Select the entire table. | 2 |
Alt+Q, then enter the search term. | Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content. | 2 |
Tab key or Shift+Tab | Move the focus to commands on the ribbon or add-in pane. | 2 |
Ctrl+Shift+F or Ctrl+Shift+P | Format fonts in the Format Cells dialog box. | 2 |
Shift+F2 | Insert a note.Open and edit a cell note. | 2 |
Ctrl+Shift+F2Ctrl+Shift+F2 | Insert a threaded comment.Open and reply to a threaded comment. | 2 |
Ctrl+Apostrophe (') | Copy a formula from the cell above the active cell into the cell or the formula bar. | 2 |
Ctrl+6 | Switch between hiding objects, displaying objects, and displaying placeholders for objects. | 2 |
Ctrl+Shift+Ampersand sign (&) | Apply an outline border to the selected cells. | 2 |
Ctrl+Shift+Underscore (_) | Remove the outline border from the selected cells. | 2 |
Alt+M, M, D | Define a name to use in references. | 2 |
Control+F9 | Minimize the active window. | 2 |
Control+Shift+Left bracket ([) | Select only cells that are directly referred to by formulas in the selection. | 2 |
Control+Shift+Left brace ({) | Select all cells that are directly or indirectly referred to by formulas in the selection. | 2 |
Control+Right bracket (]) | Select only cells with formulas that refer directly to the active cell. | 2 |
Control+Shift+Right brace (}) | Select all cells with formulas that refer directly or indirectly to the active cell. | 2 |
Shift+F5 | Display the Find dialog box. | 2 |
F6 or Shift+F6 | Switch focus between the worksheet, ribbon, task pane, and status bar. | 2 |
Alt+Enter | Insert a line break within a cell. | 2 |
Alt+F1 | Insert a chart. | 2 |
Ctrl+Alt+L | Re-apply a filter. | 2 |
Alt+H, H | Choose a fill color. | 3 |
Ctrl+Alt+5, then the Tab key repeatedly | Cycle through floating shapes, such as text boxes or images. | 3 |
Control+8 | Display or hide outline symbols. | 3 |
Control+9 | Hide selected rows. | 3 |
Alt+H | Go to the Home tab. | 5 |
Alt+N | Go to the Insert tab. | 5 |
Alt+P | Go to the Page Layout tab. | 5 |
Alt+A | Go to the Data tab. | 5 |
Alt+W | Go to the View tab. | 5 |
Alt+M | Go to the Formula tab. | 5 |
Alt+F | Open the File menu. | 5 |
Alt or F10. To move to a different tab, use access keys or the arrow keys. | Select the active tab on the ribbon and activate the access keys. | 5 |
Up arrow key | Move one cell up in a worksheet. | 5 |
Left arrow key | Move one cell left in a worksheet. | 5 |
Right arrow key | Move one cell right in a worksheet. | 5 |
Ctrl+Arrow key | Move to the edge of the current data region in a worksheet. | 5 |
Ctrl+8 | Display or hide the outline symbols. | 5 |
Ctrl+Shift+Tilde sign (~) | Apply the General number format. | 5 |
Ctrl+Q | Display the Quick Analysis options for selected cells that contain data. | 5 |
Ctrl+Alt+Shift+F9 | Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. | 5 |
Shift+F3 | Insert a function. | 5 |
F11 | Create a chart of the data in the current range in a separate Chart sheet. | 5 |
Alt+F8 | Create, run, edit, or delete a macro. | 5 |
Ctrl+M | Move the table. | 5 |
Ctrl+R | Rename the table. | 5 |
Shift+Page down | Select all cells from the current location to the last cell of the column. | 5 |
Shift+Page up | Select all cells from the current location to the first cell of the column. | 5 |
Ctrl+Home | Move to the first cell in the upper-left corner of selected table. | 5 |
Ctrl+End | Move to the last cell in the lower-right corner of selected table. | 5 |
Ctrl+Left arrow key | Move to the first cell of the selected row. | 5 |
Ctrl+Right arrow key | Move to the last cell of the selected row. | 5 |
Ctrl+Up arrow key | Move to the first cell of the selected column. | 5 |
Ctrl+Down arrow key | Move to the last cell of selected column. | 5 |
Ctrl+Esc | Close a dialog box or cancel a process, such as a paste operation. | 5 |
F5 | Open the Go To dialog box. | 5 |
Shift+F7 | Open the thesaurus. | 5 |
Shift+F11 | Insert a new sheet. * | 5 |
F1 | Display the Help window. | 5 |
Shift+F4 | Repeat Find downward. | 5 |
Ctrl+Shift+F4 | Repeat Find upward. | 5 |