| SHORTCUTS |
FUNCTION |
| F2 |
Edit cell |
| F4 |
Adds Dollars to formulas |
| F5 |
Goto a specific cell |
| F7 |
Spell Check |
| Ctrl + Shift+; |
Enter Current Time |
| Ctrl + ; |
Enter Current Date |
| Ctrl + A |
Select all content |
| Ctrl + B |
Make Bold |
| Ctrl + I |
Italic |
| Ctrl + K |
Insert link |
| Ctrl + S |
Save |
| Ctrl + V |
Copy |
| Ctrl + P |
Print Screen |
| Ctrl + Z |
Undo |
| Ctrl + Y |
Redo |
| Ctrl + C |
Copy |
| Ctrl + W |
Work Book Close |
| Ctrl + O |
Open Work Book |
| Ctrl + D |
Copy Down |
| Ctrl + R |
Copy to Right |
| Ctrl + Shift + Down |
Selects Entire Column of Table |
| Ctrl + Shift + Right |
Selects Entire Row of Table |
| Ctrl + Arrow Key |
Move to next Part |
| Ctrl + Space |
Entire Column Selected |
| shift + Space |
Entire Row Selected |
| Ctrl + "-" |
Delete Selected Column or Row |
| Ctrl + Home |
Move to Cell A1 |
| Ctrl +" ~" |
Showing Excel Formula |
| Ctrl+ "=" |
Insert above value cell |
| Ctrl + 1 |
Format Cell |
| Ctrl + Shift + 1 |
Format Numbers in Cell Format |
| Ctrl + Shift + 2 |
Format Numbers in Time Format |
| Ctrl + Shift + 3 |
Format Numbers in Date Format |
| Ctrl + Shift + 4 |
Format Numbers in Currency Format |
| Ctrl + Shift + 5 |
Format Numbers in Percentage Format |
| Ctrl + Shift + 6 |
Format Numbers in Scientific Format |
| Ctrl + Shift + "=" |
Insert a new coloumn or row |
| Alt / ? |
Shows keyboard letter to enter that tab |
| Alt + F |
File Tab |
| Alt + H |
Home TAb |
| Alt + N |
Insert Tab |
| Alt + P |
Page Layout Tab |
| Alt + M |
Fornulas Tab |
| Alt + A |
Data Tab |
| Alt + R |
Preview Tab |
| Alt + W |
View Tab |
| Alt + L |
Developer Tab |
| Alt + Y |
Help Tab |
| Alt + "=" |
Creates a Formula to sum |
| Alt + Shift + F1 |
Insert New Worksheet |
| Enter |
Enter and Move Down |
| Shift + Enter |
Enter and Move Up |
| Tab |
Enter and Move Right |
| Shift + Tab |
Enter and Move Left |
| Shift + F3 |
Excel Formula Window |
| Shift + F5 |
Search Box |
