Shortcut keys Compatibility
- Microsoft Word 97 Viewer
- Microsoft Office Word 2003
- Microsoft Word 2002
- Microsoft Word 2000
- Microsoft Word 97 Standard Edition
- Microsoft Word 2013 or higher
This Post shows most common keyboard shortcuts for MS Excel 2013 or higher. These shortcuts refer to the U.S. keyboard layout. Keys for other layouts might not correspond exactly to the keys on a U.S. keyboard.
| COMMAND | KEYSTROKE |
|---|---|
| Absolute/relative/mixed reference | F4 |
| AutoSum | Alt = |
| Bold | Ctrl-B |
| Border lines off | Ctrl-Shift _ |
| Border lines on | Ctrl-Shift & |
| Calculate active sheet | Shift-F9 |
| Calculate all worksheets | F9 |
| Close | Ctrl-W |
| Collapse selection to active cell | Shift-Backspace |
| Comment insert/edit | Shift-F2 |
| Copy | Ctrl-C |
| Copy formula from cell above | Ctrl ‘ |
| Copy value from cell above | Ctrl-Shift “ |
| Cut | Ctrl-X |
| Date | Ctrl ; |
| Delete range | Ctrl – |
| Delete to end of line | Ctrl-Del |
| Show values/formulas | Ctrl ` |
| Edit cell | F2 |
| Enter formula as array | Ctrl-Shift-Enter |
| Fill down | Ctrl-D |
| Fill right | Ctrl-R |
| Find | Ctrl-F |
| Format commas (2 decimal places) | Ctrl-Shift ! |
| Format currency (2 decimal places) | Ctrl-Shift $ |
| Format date (day, month, year) | Ctrl-Shift # |
| Format exponential number (2 decimal places) | Ctrl-Shift ^ |
| Format general number | Ctrl-Shift ~ |
| Format percentage (0 decimal places) | Ctrl-Shift % |
| Format time (hour and minute) | Ctrl-Shift @ |
| Formula | = |
| Function Wizard | Shift-F3 |
| GoTo | Ctrl-G |
| Group row/column | Alt-Shift-Right |
| Hard Return in cell | Alt-Enter |
| Hide selected column(s) | Ctrl-0 (zero) |
| Hide selected row(s) | Ctrl-9 |
| Insert chart sheet | F11 |
| Insert Function components | Ctrl-Shift-A |
| Insert range | Ctrl-Shift-Plus |
| Insert worksheet | Shift-F11 |
| Italics | Ctrl-I |
| Menu bar | F10 |
| Move between noncontiguous selections | Ctrl-Alt-Left/Right |
| Move left/right one screen | Alt-PgUp/PgDn |
| Move to beginning of worksheet | Ctrl-Home |
| Move to edge of region | Ctrl-Arrow |
| Move to end of row | End, Enter |
| Move to end of worksheet | Ctrl-End |
| Move to next corner of selection | Ctrl . |
| Move up through a selection | Shift-Enter |
| Name a range (Insert/Name/Create) | Ctrl-Shift-F3 |
| Name a range (Insert/Name/Define) | Ctrl-F3 |
| New | Ctrl-N |
| Next window | Ctrl-F6 |
| Next worksheet | Ctrl-PgUp |
| Open | Ctrl-O |
| Outline symbols display/hide | Ctrl-8 |
| Paste | Ctrl-V |
| Paste named range (Insert/Name/Paste) | F3 |
| Previous window | Ctrl-Shift-F6 |
| Previous worksheet | Ctrl-PgDn |
| Ctrl-P | |
| Repeat Find | Shift-F4 |
| Repeat/Redo | Ctrl-Y |
| Replace | Ctrl-H |
| Save | Ctrl-S |
| Save As | F12 |
| Scroll to display active cell | Ctrl-Backspace |
| Select array to which active cell belongs | Ctrl / |
| Select cells directly referred to by selected formula | Ctrl [ |
| Select cells referred to by selected formula | Ctrl-Shift { |
| Select cells with comments | Ctrl-Shift ? |
| Select column | Ctrl-spacebar |
| Select current region | Ctrl-Shift * |
| Select formulas that directly refer to active cell | Ctrl ] |
| Select formulas that refer to active cell | Ctrl-Shift } |
| Select objects on worksheet | Ctrl-Shift-spacebar |
| Select row | Shift-spacebar |
| Select to beginning of row | Shift-Home |
| Select to beginning of worksheet | Ctrl-Shift-Home |
| Select to edge of region | Ctrl-Shift-(Arrow) |
| Select to end of row | End, Shift-Enter |
| Select to end of worksheet | Ctrl-Shift-End |
| Select visible cells in selection | Alt ; |
| Select worksheet | Ctrl-A |
| Shortcut menu | Shift-F10 |
| Spelling and Grammar check | F7 |
| Strikethrough on/off | Ctrl-5 |
| Style box | Alt ‘ |
| Tab inserted | Ctrl-Alt-Tab |
| Time | Ctrl-Shift-Colon |
| Underline | Ctrl-U |
| Undo | Ctrl-Z |
| Ungroup row/column | Alt-Shift-Left |
| Unhide column(s) | Ctrl-Shift ) |
| Unhide row(s) | Ctrl-Shift ( |
