Keyboard Shortcuts (Excel)
Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions.
Frequently used shortcuts
To do this |
Press |
| Create A New Workbook | Ctrl + N |
| Open An Existing Workbook | Ctrl + O |
| Save A Workbook/Spreadsheet | Ctrl + S |
| Close The Current Workbook | Ctrl + W |
| Close Excel | Ctrl + F4 |
| Move To The Next Sheet | Ctrl + PageDown |
| Move To The Previous Sheet | Ctrl + PageUp |
| Go To The Data Tab | Alt + A |
| Go To The View Tab | Alt + W |
| Go To The Formula Tab | Alt + M |
| Edit A Cell | F2 |
| Copy And Paste Cells | Ctrl + C, Ctrl + V |
| Italicize And Make The Font Bold | Ctrl + I, Ctrl + B |
| Center Align Cell Contents | Alt + H + A + C |
| Fill Color | Alt + H + H |
| Add A Border | Alt + H + B |
| Remove Outline Border | Ctrl + Shift + _ |
| Add An Outline To The Select Cells | Ctrl + Shift + & |
| Strikeout Selected Cell(s) | Ctrl + 5 |
| Move To The Next Cell | Tab |
| Move To The Previous Cell | Shift + Tab |
| Select All The Cells On The Right | Ctrl + Shift + Right arrow |
| Select All The Cells On The Left | Ctrl + Shift + Left Arrow |
| Select The Column From The Selected Cell To The End Of The Table | Ctrl + Shift + Down Arrow |
| Select All The Cells Above The Selected Cell | Ctrl + Shift + Up Arrow |
| Select All The Cells Below The Selected Cell | Ctrl + Shift + Down Arrow |
| Add A Comment To A Cell | Shift + F2 |
| Delete A Cell Comment | Shift + F10 + D |
| Display Find And Replace | Ctrl + H |
| Insert The Current Date | Ctrl + ; |
| Insert Current Time | Ctrl + Shift + : |
| Insert A Hyperlink | Ctrl + k |
| Apply The Currency Format | Ctrl + Shift + $ |
| Apply The Percent Format | Ctrl + Shift + % |
| Go To The “Tell Me What You Want Do” Box | Alt + Q |
| Select The Entire Row | Shift + Space |
| Select The Entire Column | Ctrl + Space |
| Delete A Column | Alt+H+D+C |
| Delete A Row | Shift + Space, Ctrl + - |
| Hide Selected Row | Ctrl + 9 |
| Unhide Selected Row | Ctrl + Shift + 9 |
| Hide A Selected Column | Ctrl + 0 |
| Unhide A Selected Column | Ctrl + Shift + 0 |
| Group Rows Or Columns | Alt + Shift + Right arrow |
| Ungroup Rows Or Columns | Alt + Shift + Left arrow |