|
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 |
| |
|