Shortcut Microsoft Excel is a key on the keyboard which consists of one or a combination of two key keyboard that can perform the functions of the Microsoft Excel application.
Microsoft Excel keyboard shortcuts
Shortcuts in Microsoft Excel is used to facilitate our work in using Microsoft Excel. So, to carry out basic functions in Microsoft Excel can be done simply by pressing a certain key on the keyboard on your computer. Surely you have to memorize the shortcuts to be more efficient in its use. To further speed up work on Ms. Excel we can use some shortcuts in Microsoft Excel as below:
Action |
Keystroke |
Document actions |
Open a file |
CTRL+O |
New file |
CTRL+N |
Save As |
F12 |
Save |
CTRL+S |
Print |
CTRL+P |
Find |
CTRL+F |
Replace |
CTRL+H |
Go to |
F5 |
Cursor Movement |
One cell up |
up arrow |
One cell down |
down arrow |
One cell right |
Tab |
One cell left |
SHIFT+Tab |
Top of worksheet (cell A1) |
CTRL+Home |
End of worksheet(last cell with data) |
CTRL+End |
End of row |
Home |
End of column |
CTRL+left arrow |
Move to next worksheet |
CTRL+PageDown |
Formulas |
Apply AutoSum |
ALT+= |
Current date |
CTRL+; |
Current time |
CTRL+: |
Spelling |
F7 |
Help |
F1 |
Macros |
ALT+F8 |
Microsoft Excel keyboard shortcuts
Action |
Keystroke |
Selecting Cells |
All cells left of current cell |
SHIFT+left arrow |
All cells right of current cell |
SHIFT+right arrow |
Entire column |
CTRL+Spacebar |
Entire row |
SHIFT+Spacebar |
Entire worksheet |
CTRL+A |
Text Style |
Bold |
CTRL+B |
Italics |
CTRL+I |
Underline |
CTRL+U |
Strikethrough |
CTRL+5 |
Formatting |
Edit active cell |
F2 |
Format as currency with 2 decimal places |
SHIFT+CTRL+$ |
Format as percent with no decimal places |
SHIFT+CTRL+% |
Cut |
CTRL+X |
Copy |
CTRL+C |
Paste |
CTRL+V |
Undo |
CTRL+Z |
Redo |
CTRL+Y |
Format cells dialog box |
CTRL+1 |
Tags:
Tips and Tricks Excel