learningPC.net
Excel XP
Shorcut keys.
|
What You Want to Do |
Keystroke(s) |
|
Begin a Formula |
= |
|
Calculate the Active
Worksheet |
Shift + F9 |
|
Create a Chart |
F11 or Alt + F1 |
|
Display the Go To Dialogue
Box |
F5 |
|
Fill Down |
Ctrl + D |
|
Go to Previous Worksheet |
Ctrl + Page Up |
|
Insert today’s date |
Ctrl + ; |
|
Jump to Last cell on
worksheet |
Ctrl + End |
|
Paste |
Ctrl + V |
|
Print |
Ctrl + P |
|
Select All |
Ctrl + A |
|
Select Column |
Ctrl + Space |
|
Undo |
Ctrl + Z |
|
Calculate all sheets |
F9 |
|
Copy |
Ctrl + C |
|
Display the Format Cells
Dialogue Box |
Ctrl + 1 |
|
Fill selected cells with
current cell |
Ctrl + Enter |
|
Go to the Next Worksheet |
Ctrl + Page Down |
|
Insert the current time |
Ctrl + : |
|
Jump to Beginning of
Workstation |
Ctrl + Home |
|
Open |
Ctrl + O |
|
Paste a function into a
formula |
Shift + F3 |
|
Save |
Ctrl + S |
|
Select cells that reference
the cell you’re in |
Ctrl + ] |
|
Select Row |
Shift + Space |
|
|
|