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 |
|