Excels Keyboard ShortcutsFebruary 2, 2010 |
Menu equivalent |
Version | |||||
|
Ctrl+A |
Select All |
None |
All | ||||
|
Ctrl+B |
Bold |
Format, Cells, Font, Font Style, Bold |
All | ||||
|
Ctrl+C |
Copy |
Edit, Copy |
All | ||||
|
Ctrl+D |
Fill Down |
Edit, Fill, Down |
All | ||||
|
Ctrl+F |
Find |
Edit, Find |
All | ||||
|
Ctrl+G |
Goto |
Edit, Goto |
All | ||||
|
Ctrl+H |
Replace |
Edit, Replace |
All | ||||
|
Ctrl+I |
Italic |
Format, Cells, Font, Font Style, Italic |
All | ||||
|
Ctrl+K |
Insert Hyperlink |
Insert, Hyperlink |
Excel 97/2000 | ||||
|
Ctrl+N |
New Workbook |
File, New |
All | ||||
|
Ctrl+O |
Open |
File, Open |
All | ||||
|
Ctrl+P |
|
File, Print |
All | ||||
|
Ctrl+R |
Fill Right |
Edit, Fill Right |
All | ||||
|
Ctrl+S |
Save |
File, Save |
All | ||||
|
Ctrl+U |
Underline |
Format, Cells, Font, Underline, Single |
All | ||||
|
Ctrl+V |
Paste |
Edit, Paste |
All | ||||
|
Ctrl W |
Close |
File, Close |
Excel 97/2000 | ||||
|
Ctrl+X |
Cut |
Edit, Cut |
All | ||||
|
Ctrl+Y |
Repeat |
Edit, Repeat |
All | ||||
|
Ctrl+Z |
Undo |
Edit, Undo |
All | ||||
|
F1 |
Help |
Help, Contents and Index |
All | ||||
|
F2 |
Edit |
None |
All | ||||
|
F3 |
Paste Name |
Insert, Name, Paste |
All | ||||
|
F4 |
Repeat last action |
Edit, Repeat. Works while not in Edit mode. |
All | ||||
|
F4 |
While typing a formula, switch between absolute/relative refs |
None |
All | ||||
|
F5 |
Goto |
Edit, Goto |
All | ||||
|
F6 |
Next Pane |
None |
All | ||||
|
F7 |
Spell check |
Tools, Spelling |
All | ||||
|
F8 |
Extend mode |
None |
All | ||||
|
F9 |
Recalculate all workbooks |
Tools, Options, Calculation, Calc,Now |
All | ||||
|
F10 |
Activate Menubar |
N/A |
All | ||||
|
F11 |
New Chart |
Insert, Chart |
All | ||||
|
F12 |
Save As |
File, Save As |
All Posted by chamarath thilakasiri. |