| |
|
|
|
| Excel Tips and Tricks |
|
|
|
|
| Command Name |
Key Stroke |
Category |
Comments |
| Clear Everything Within Selection |
Alt eaa |
Clear/Delete |
|
| Delete Selection |
Alt ed |
Clear/Delete |
|
| Edit Redo (Reverse Undo) |
Ctrl y / Alt er |
Commands |
|
| Edit Undo |
Ctrl z / Alt eu |
Commands |
|
| Repeat Last Command |
F4 / Ctrl y / Alt Enter |
Commands |
Use F4 while outside Formula Bar |
| Copy Down (Excel) |
Ctrl d |
Copy/Paste |
|
| Copy Right (Excel) |
Ctrl r |
Copy/Paste |
|
| Paste Special - Formats |
Alt est Enter |
Copy/Paste |
Copies formats and nothing else |
| Paste Special - Formulas |
Alt esf Enter |
Copy/Paste |
Copies formulas and nothing else |
| Paste Special - Values |
Alt esv Enter |
Copy/Paste |
Copies values and nothing else |
| Copy |
Ctrl c / Alt ec |
Cut/Copy/Move/Paste/Insert |
|
| Cut |
Ctrl x / Alt et |
Cut/Copy/Move/Paste/Insert |
|
| Insert (Copied) Cells |
Alt ie |
Cut/Copy/Move/Paste/Insert |
|
| Paste |
Ctrl v / Alt ep |
Cut/Copy/Move/Paste/Insert |
|
| File Close |
Alt fc |
Files |
|
| File New |
Ctrl n / Alt fn |
Files |
|
| File Open |
Ctrl o / Alt fo / Ctrl F12 |
Files |
|
| File Save |
Ctrl s / Alt fs |
Files |
|
| File Save As |
F12 / Alt fa |
Files |
|
| Cell Formatting Dialog Box |
Ctrl 1 / Alt oe |
Formatting |
|
| Bold |
Ctrl b |
Formatting - Font |
|
| Italics |
Ctrl i |
Formatting - Font |
|
| Underline |
Ctrl u |
Formatting - Font |
|
| Column Autofit |
Alt oca |
Formatting - Rows/Columns |
|
| Absolute/Relative Reference |
F4 |
Formulas |
Use F4 while in Formula Bar |
| Enter/Exit Cell Formula Bar |
F2 |
Formulas |
You can use Esc to exit Formula Bar as well |
| Finish Entry |
Enter |
Formulas |
Moves selection depending on Excel user preferences (Shift Enter moves selection in opposite direction |
| Finish Entry and Move Left |
Shift Tab |
Formulas |
|
| Finish Entry and Move Right |
Tab |
Formulas |
|
| Insert Function (Function Wizard) |
Shift F3 |
Formulas |
|
| Sum Formula |
Alt = |
Formulas |
|
| Insert Column |
Alt ic |
Insert New |
|
| Insert Row |
Alt ir |
Insert New |
|
| Go To... |
F5 / Ctrl g / Alt eg |
Navigation |
|
| Move Down |
Down Arrow |
Navigation |
|
| Move Left |
Left Arrow |
Navigation |
|
| Move Right |
Right Arrow |
Navigation |
|
| Move Up |
Up Arrow |
Navigation |
|
| Next Workbook |
Ctrl Tab / Ctrl F6 |
Navigation |
|
| Next Worksheet |
Ctrl Page Down |
Navigation |
|
| Page Down |
Page Down |
Navigation |
|
| Page Up |
Page Up |
Navigation |
|
| Previous Workbook |
Ctrl Shift Tab / Ctrl Shift F6 |
Navigation |
|
| Previous Worksheet |
Ctrl Page Up |
Navigation |
|
| Quick Move Down |
Ctrl Down Arrow |
Navigation |
|
| Quick Move Left |
Ctrl Left Arrow |
Navigation |
|
| Quick Move Right |
Ctrl Right Arrow |
Navigation |
|
| Quick Move Up |
Ctrl Up Arrow |
Navigation |
|
| Activate/Deactivate Menu Bar |
F10 / Alt |
Other |
Use arrows or menu accelerators to move through menu options |
| Help |
F1 |
Other |
|
| Insert Name (Define) |
Alt ind / Ctrl F3 |
Other |
|
| File Clear Print Area |
Alt ftc |
Printing |
|
| File Page Setup |
Alt fu |
Printing |
|
| File Print |
Ctrl p / Alt fp |
Printing |
|
| File Print Preview |
Alt fv |
Printing |
Use Esc to exit print preview mode |
