Read Time:2 Minute, 7 Second
Here is a list of the shortcuts that can make your life easy while using Excel. Use Excel 2013 for the best experience and all the shortcuts works with Excel 2013.
I have included the most used shortcuts in Excel. If you have any more shortcuts please leave a comment.
Shortcuts
| Shortcut | Description |
| Ctrl+N | Create new workbook |
| Ctrl+O | Open workbook |
| Ctrl+S | Save workbook |
| F12 | Save as |
| Ctrl+P | Print file |
| Ctrl+F2 | Open print preview window |
| Ctrl+F4 | Close current workbook |
| Alt+F4 | Close Excel |
| Ctrl+Alt+V | Display the Paste Special dialog box |
| Ctrl+H | Display find and replace |
| Shortcut | Description |
| Alt+F1 | Create embedded chart |
| F11 | Create a chart in a new worksheet |
| Ctrl+Shift+L | Toggle Autofilter |
| Alt↓ | Activate filter |
| Ctrl+T | Insert table |
| Shift+Space | Select table row |
| Ctrl+Space | Select table column |
| Home | Move to the beginning of the row |
| Shift+Space | Select entire row |
| Ctrl+Space | Select entire column |
| Shortcut | Description |
| Shift+Click | Add adjacent cells to the selection |
| Ctrl+Click | Add non-adjacent cells to the selection |
| Shift+F8 | Toggle add to selection mode |
| Enter | Move active cells down in the selection |
| Shift+Enter | Move active cells up in the selection |
| Ctrl+G | Display the “GoTo” dialog box |
| Ctrl+Shift+* | Select the current region around the active cell |
| Ctrl+/ | Select current array |
| Ctrl+\ | Select row differences |
| Ctrl+Shift+| | Select column differences |
| Shortcut | Description |
| Alt+; | Select visible cells only |
| F2 | Edit the active cell |
| Shift+F2 | Insert or edit the comment |
| Ctrl+Delete | Delete to end of line |
| Alt+Enter | Start a new line in the same cell |
| Ctrl+; | Insert current date |
| Ctrl+Shift+: | Insert current time |
| Ctrl+D | Fill down from the cell above |
| Ctrl+R | Fill right from cell left |
| Ctrl+’ | Copy the formula from the cell above |
| Shortcut | Description |
| Ctrl+Shift+” | Copy value from the cell above |
| Ctrl+K | Add hyperlink |
| Ctrl+E | Flash fill |
| Ctrl+1 | Format (almost) anything |
| Ctrl+Shift+F | Display Format Cells with Font tab selected |
| Ctrl+5 | Apply or remove strikethrough formatting |
| Ctrl+B | Apply or remove bold formatting |
| Ctrl+I | Apply or remove italic formatting |
| Ctrl+U | Apply or remove underscoring |
| Alt+H+A+C | Align centre |
| Shortcut | Description |
| Alt+H+A+L | Align Left |
| Alt+H+A+R | Align Right |
| Ctrl+Shift+~ | Apply general format |
| Ctrl+Shift+$ | Apply currency format |
| Ctrl+Shift+% | Apply percentage format |
| Ctrl+Shift+^ | Apply scientific format |
| Ctrl+Shift+# | Apply date format |
| Ctrl+Shift+@ | Apply Time format |
| Ctrl+Shift+! | Apply Number format |
| Ctrl+Shift+& | Add border outline |
| Shortcut | Description |
| Ctrl+Shift+_ | Remove borders |
| Shift+F3 | Open the Insert Function Dialog Box |
| Alt+= | Autosum selected cells |
| Ctrl+` | Toggle formulas on and off |
| F9 | Calculate worksheets |
| Shift+F9 | Calculate worksheets |
| Ctrl+Shift+U | Expand or collapse the formula bar |
| Ctrl+F3 | Define name |
| Ctrl+Shift+F3 | Define name using row and column labels |
| Ctrl+Shift++ | Display Insert Dialog box |
| Shortcut | Description |
| Ctrl+- | Display Delete dialog box |
| Ctrl+0 | Hide columns |
| Ctrl+9 | Hide rows |
| Ctrl+Shift+0 | Unhide columns |
| Ctrl+Shift+9 | Unhide rows |
| Ctrl+8 | Hide or show outline symbols |
| Shift+F11 | Insert new worksheet |
| Ctrl+PgDn/Ctrl+PgUp | Go to the next/prev worksheet |
| Ctrl+F9/Ctrl+F10 | Minimize/Maximize the current workbook window CtrlF9 |
| Shift+Click | Select adjacent worksheets |
| F7 | Open the Spelling dialog box |
| Shift+F7 | Open Thesaurus dialog box |
| Alt+F8 | Open the Macro dialog box |
| Ctrl+6 | Hide or show objects |
| Alt+’ | Display Modify Cell Style dialog box |
| Shift+F10 | Display right-click menu |
Happy
25 %
Sad
0 %
Excited
0 %
Sleepy
25 %
Angry
50 %
Surprise
0 %
