Useful - excel shortcut
Ctrl+A |
Select All |
None |
Ctrl+B |
Bold |
Format, Cells, Font, Font Style, Bold |
Ctrl+C |
Copy |
Edit, Copy |
Ctrl+D |
Fill Down |
Edit, Fill, Down |
Ctrl+F |
Find |
Edit, Find |
Ctrl+G |
Goto |
Edit, Goto |
Ctrl+H |
Replace |
Edit, Replace |
Ctrl+I |
Italic |
Format, Cells, Font, Font Style, Italic |
Ctrl+K |
Insert Hyperlink |
Insert, Hyperlink |
Ctrl+N |
New Workbook |
File, New |
Ctrl+O |
Open |
File, Open |
Ctrl+P |
|
File, Print |
Ctrl+R |
Fill Right |
Edit, Fill Right |
Ctrl+S |
Save |
File, Save |
Ctrl+U |
Underline |
Format, Cells, Font, Underline, Single |
Ctrl+V |
Paste |
Edit, Paste |
Ctrl W |
Close |
File, Close |
Ctrl+X |
Cut |
Edit, Cut |
Ctrl+Y |
Repeat |
Edit, Repeat |
Ctrl+Z |
Undo |
Edit, Undo |
F1 |
Help |
Help, Contents and Index |
F2 |
Edit |
None |
F3 |
Paste Name |
Insert, Name, Paste |
F4 |
Repeat last action |
Edit, Repeat. Works while not in Edit mode. |
F4 |
While typing a formula, switch between absolute/relative refs |
None |
F5 |
Goto |
Edit, Goto |
F6 |
Next Pane |
None |
F7 |
Spell check |
Tools, Spelling |
F8 |
Extend mode |
None |
F9 |
Recalculate all workbooks |
Tools, Options, Calculation, Calc,Now |
F10 |
Activate Menubar |
N/A |
F11 |
New Chart |
Insert, Chart |
F12 |
Save As |
File, Save As |
Ctrl+: |
Insert Current Time |
None |
Ctrl+; |
Insert Current Date |
None |
Ctrl+" |
Copy Value from Cell Above |
Edit, Paste Special, Value |
Ctrl+' |
Copy Fromula from Cell Above |
Edit, Copy |
Shift |
Hold down shift for additional functions in Excel's menu |
none |
Shift+F1 |
What's This? |
Help, What's This? |
Shift+F2 |
Edit cell comment |
Insert, Edit Comments |
Shift+F3 |
Paste function into formula |
Insert, Function |
Shift+F4 |
Find Next |
Edit, Find, Find Next |
Shift+F5 |
Find |
Edit, Find, Find Next |
Shift+F6 |
Previous Pane |
None |
Shift+F8 |
Add to selection |
None |
Shift+F9 |
Calculate active worksheet |
Calc Sheet |
Shift+F10 |
Display shortcut menu |
None |
Shift+F11 |
New worksheet |
Insert, Worksheet |
Shift+F12 |
Save |
File, Save |
Ctrl+F3 |
Define name |
Insert, Names, Define |
Ctrl+F4 |
Close |
File, Close |
Ctrl+F5 |
XL, Restore window size |
Restore |
Ctrl+F6 |
Next workbook window |
Window, ... |
Shift+Ctrl+F6 |
Previous workbook window |
Window, ... |
Ctrl+F7 |
Move window |
XL, Move |
Ctrl+F8 |
Resize window |
XL, Size |
Ctrl+F9 |
Minimize workbook |
XL, Minimize |
Ctrl+F10 |
Maximize or restore window |
XL, Maximize |
Ctrl+F11 |
Inset 4.0 Macro sheet |
None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro |
Ctrl+F12 |
File Open |
File, Open |
Alt+F1 |
Insert Chart |
Insert, Chart... |
Alt+F2 |
Save As |
File, Save As |
Alt+F4 |
Exit |
File, Exit |
Alt+F8 |
Macro dialog box |
Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions |
Alt+F11 |
|