Excel shortcuts (Basic)

Excel shortcuts
Shortcut key | Action | Menu equivalent comments | version |
---|---|---|---|
Ctrl+A | Select All | None | All |
Ctrl+B | Bold | Format, Cells, Font, Font Style, Bold | All |
Ctrl+C | Copy | Edit, Copy | All |
Ctrl+D | Fill Down | Edit, Fill, Down | All |
Ctrl+F | Find | Edit, Find | All |
Ctrl+G | Goto | Edit, Goto | All |
Ctrl+H | Replace | Edit, Replace | All |
Ctrl+I | Italic | Format, Cells, Font, Font Style, Italic | All |
Ctrl+K | Insert Hyperlink | Insert, Hyperlink | Excel 97/2000 + |
Ctrl+N | New Workbook | File, New | All |
Ctrl+O | Open | File, Open | All |
Ctrl+P | File, Print | All | |
Ctrl+R | Fill Right | Edit, Fill Right | All |
Ctrl+S | Save | File, Save | All |
Ctrl+U | Underline | Format, Cells, Font, Underline, Single | All |
Ctrl+V | Paste | Edit, Paste | All |
Ctrl W | Close | File, Close | Excel 97/2000 + |
Ctrl+X | Cut | Edit, Cut | All |
Ctrl+Y | Repeat | Edit, Repeat | All |
Ctrl+Z | Undo | Edit, Undo | All |
F1 | Help | Help, Contents and Index | All |
F2 | Edit | None | All |
F3 | Paste Name | Insert, Name, Paste | All |
F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. | All |
F4 | While typing a formula, switch between absolute/relative refs | None | All |
F5 | Goto | Edit, Goto | All |
F6 | Next Pane | None | All |
F7 | Spell check | Tools, Spelling | All |
F8 | Extend mode | None | All |
F9 | Recalculate all workbooks | Tools, Options, Calculation, Calc Now | All |
F10 | Activate Menubar | N/A | All |
F11 | New Chart | Insert, Chart | All |
F12 | Save As | File, Save As | All |
Ctrl+: | Insert Current Time | None | All |
Ctrl+; | Insert Current Date | None | All |
Ctrl+" | Copy Value from Cell Above | Edit, Paste Special, Value | All |
Ctrl+’ | Copy Formula from Cell Above | Edit, Copy | All |
Shift | Hold down shift for additional functions in Excel’s menu | none | Excel 97/2000 + |
Shift+F1 | What’s This? | Help, What’s This? | All |
Shift+F2 | Edit cell comment | Insert, Edit Comments | All |
Shift+F3 | Paste function into formula | Insert, Function | All |
Shift+F4 | Find Next | Edit, Find, Find Next | All |
Shift+F5 | Find | Edit, Find, Find Next | All |
Shift+F6 | Previous Pane | None | All |
Shift+F8 | Add to selection | None | All |
Shift+F9 | Calculate active worksheet | Tools, Options, Calculation, Calc Sheet | All |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | None | Excel 97/2000 + |
Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. | None | Excel 97/2000 + |
Shift+F10 | Display shortcut menu | None | All |
Shift+F11 | New worksheet | Insert, Worksheet | All |
Comments (0)