Shortcut key | Action |
---|---|
Ctrl+A | Select All |
Ctrl+B | Bold |
Ctrl+C | Copy |
Ctrl+D | Fill Down |
Ctrl+E | Flash Fill |
Ctrl+F | Find |
Ctrl+G | Goto |
Ctrl+I | Italic |
Ctrl+K | Insert Hyperlink |
Ctrl+N | New Workbook |
Ctrl+O | Open |
Ctrl+P | |
Ctrl+R | Fill Right |
Ctrl+S | Save |
Ctrl+U | Underline |
Ctrl+V | Paste |
Ctrl W | Close |
Ctrl+X | Cut |
Ctrl+Y | Repeat |
Ctrl+Z | Undo |
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat last action |
F4 | While typing a formula, switch between absolute/ relative refs |
F5 | Go to |
F6 | Next Pane |
F7 | Spell check |
F8 | Extend mode |
F9 | Recalculate all workbooks |
F10 | Activate Menubar |
F11 | New Chart |
F12 | Save As |
Ctrl+: | Insert Current Time |
Ctrl+; | Insert Current Date |
Ctrl+" | Copy Value from Cell Above |
Ctrl+’ | Copy Formula from Cell Above |
Shift | Hold down shift for additional functions in Excel’s menu |
Shift+F1 | What’s This? |
Shift+F2 | Edit cell comment |
Shift+F3 | Paste function into formula |
Shift+F4 | Find Next |
Shift+F5 | Find |
Shift+F6 | Previous Pane |
Shift+F8 | Add to selection |
Shift+F9 | Calculate active worksheet |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculate |
Shift+F10 | Display shortcut menu |
Shift+F11 | New worksheet |
Shift+F12 | Save |
Ctrl+F3 | Define name |
Ctrl+F4 | Close |
Ctrl+F5 | XL, Restore window size |
Ctrl+F6 | Next workbook window |
Shift+Ctrl+F6 | Previous workbook window |
Ctrl+F7 | Move window |
Ctrl+F8 | Resize window |
Ctrl+F9 | Minimize workbook |
Ctrl+F10 | Maximize or restore window |
Ctrl+F11 | Inset 4.0 Macro sheet |
Ctrl+F12 | File Open |
Alt+F1 | Insert Chart |
Alt+F2 | Save As |
Alt+F4 | Exit |
Alt+F8 | Macro dialog box |
Alt+F11 | Visual Basic Editor |
Ctrl+Shift+F3 | Create name by using names of row and column labels |
Ctrl+Shift+F6 | Previous Window |
Ctrl+Shift+F12 | |
Alt+Shift+F1 | New worksheet |
Alt+Shift+F2 | Save |
Alt+= | AutoSum |
Ctrl+` | Toggle Value/Formula display |
Ctrl+Shift+A | Insert argument names into formula |
Alt+Down arrow | Display AutoComplete list |
Alt+’ | Format Style dialog box |
Ctrl+Shift+~ | General format |
Ctrl+Shift+! | Comma format |
Ctrl+Shift+@ | Time format |
Ctrl+Shift+# | Date format |
Ctrl+Shift+$ | Currency format |
Ctrl+Shift+% | Percent format |
Ctrl+Shift+^ | Exponential format |
Ctrl+Shift+& | Place outline border around selected cells |
Ctrl+Shift+_ | Remove outline border |
Ctrl+Shift+* | Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. |
Ctrl+- | Delete |
Ctrl+1 | Format cells dialog box |
Ctrl+2 | Bold |
Ctrl+3 | Italic |
Ctrl+4 | Underline |
Ctrl+5 | Strikethrough |
Ctrl+6 | Show/Hide objects |
Ctrl+7 | Show/Hide Standard toolbar |
Ctrl+8 | Toggle Outline symbols |
Ctrl+9 | Hide rows |
Ctrl+0 | Hide columns |
Ctrl+Shift+( | Unhide rows |
Ctrl+Shift+) | Unhide columns |
Alt or F10 | Activate the menu |
Ctrl+Tab | In toolbar: next toolbar In a workbook: activate next workbook |
Tab | Next tool |
Shift+Tab | Previous tool |
Enter | Do the command |
Alt+Enter | Start a new line in the same cell. |
Ctrl+Enter | Fill the selected cell range with the current entry. |
Shift+Ctrl+F | Font Drop Down List |
Shift+Ctrl+P | Point size Drop Down List |
Ctrl+Spacebar | Select the entire column |
Shift+Spacebar | Select the entire row |
CTRL+Backspace | Jump back to the active cell and bring it into view |
CTRL+/ | Select the array containing the active cell. |
CTRL+SHIFT+O | Select all cells that contain comments. |
CTRL+\ | In a selected row, select the cells that don’t match the formula or static value in the active cell. |
CTRL+SHIFT+| | In a selected column, select the cells that don’t match the formula or static value in the active cell. |
CTRL+[ | Select all cells directly referenced by formulas in the selection. |
CTRL+SHIFT+{ | Select all cells directly or indirectly referenced by formulas in the selection. |
CTRL+] | Select cells that contain formulas that directly reference the active cell. |
CTRL+SHIFT+} | Select cells that contain formulas that directly or indirectly reference the active cell. |
ALT+; | Select the visible cells in the current selection. |
QSHIFT+BACKSPACE | With multiple cells selected, select only the active cell. |
Ctrl+Alt+L | Reapply the filter and sort on the current range so that changes you've made are included |
Ctrl+Alt+V | Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. |