| File Management |
|
| New |
Ctrl N or Alt F N |
| Open |
Ctrl O or Alt F O or Ctrl F12 |
| Close |
Alt F C |
| Print |
Ctrl P or Alt F P |
| Save |
Ctrl S or Alt F S |
| Save As |
F12 or Alt F A |
| Set Print Area |
Alt F T S |
| Clear Print Area |
Alt F T C |
| Insert Page Break |
Alt I B |
| Page Setup |
Alt F U |
| Print Preview |
Alt F V |
| |
|
| Formatting |
|
| Undo Last Action |
Ctrl Z or Alt E U |
| Redo (Reverse Undo) |
Ctrl Y or Alt E R |
| Repeat Last Action |
F4 or Ctrl Y or Alt Enter |
| Enter or Exit Cell or Formula Bar |
F2 |
| Absolute or Relative Reference |
F4 |
| |
|
| Format Cells |
|
| Bold |
Ctrl B |
| Italics |
Ctrl I |
| Underline |
Ctrl U |
| Strikethrough |
Ctrl 5 |
| Border Outline |
Ctrl Shift 7 |
| Remove Borders |
Ctrl Shift – |
| Format Cells |
Ctrl 1 |
| |
|
| Edit |
|
| Cut |
Ctrl X |
| Copy |
Ctrl C |
| Paste |
Ctrl V |
| Paste Special – Formula |
Alt ESF, Enter |
| Paste Special – Format |
Alt EST, Enter |
| Paste Special – Value |
Alt ESV, Enter |
| Copy Right |
Select empty cells to the right of filled cell, then Ctrl R |
| Copy Down |
Select empty cells below filled cell, then Ctrl D |
| |
|
| Formulas |
|
| Sum Formula |
Alt= |
| Function Wizard |
Shift F3 |
| |
|
| Moving Around Excel |
|
| Quick move |
Ctrl and Arrow in desired direction |
| Move To Column A |
Home |
| Move To Cell A1 |
Ctrl Home |
| Move To Bottom Right Cell |
Ctrl End |
| Page Left |
Alt Page Up |
| Page Right |
Alt Page Down |
| Next Worksheet |
Ctrl Page Down |
| Previous Worksheet |
Ctrl Page Up |
| Next Workbook |
Ctrl Tab or Ctrl F6 |
| Previous Workbook |
Ctrl Shift Tab or Ctrl Shift F6 |
| Go To |
F5 or Ctrl G or Alt E,G |
| |
|
| Selecting Cells |
|
| Highlight Cells |
Shift Arrow in desired direction |
| Quick Highlight |
Ctrl Shift Arrow in desired direction |
| Select To Column A |
Shift Home |
| Select To Cell A1 |
Ctrl Shift Home |
| Select To Bottom Right Cell |
Ctrl Shift End |
| Selection Page Up or Down |
Shift Page Up or Down |
| Selection Page Left or Right |
Shift Alt Page Up or Down |
| Select Row |
Shift Spacebar |
| Select Column |
Ctrl Spacebar |
| Select Entire Worksheet |
Ctrl A |
| |
|
| Insert |
|
| Insert today’s DATE |
Ctrl ; |
| Insert Row |
Alt IR |
| Insert Column |
Alt IC |
| Copy or Move Sheet |
Alt EM |
| Insert New Worksheet |
Alt IW or Shift F11 |
| |
|
| Dependents and Precedents |
|
| Highlight Direct Cell Precedents |
Ctrl [ |
| Highlight Direct Cell Dependents |
Ctrl ] |
| Show Precedent Arrows Alt TUT |
|
| Show Dependent Arrows Alt TUD |
|
| |
|
| Find and Replace |
|
| Find |
Ctrl F |
| Replace |
Ctrl H |
| |
|
| View |
|
| Freeze or Unfreeze Window Panes |
Alt WF |
| Split Windows |
Alt WS |
| View Zoom |
Alt VZ |
| View Page Breaks |
Alt VP |
| View Normal |
Alt VN |
| Define Name |
Alt IND or Ctrl F3 |
| Insert Comment |
Alt IM or Shift F2 |
| Clear Comments |
Alt EAM |
| View Macros |
Alt F8 |
| View VBA |
Alt F11 |
| |
|
| Fit / Hide Rows and Columns |
|
| Column Autofit |
Alt OCA |
| Row Autofit |
Alt ORA |
| Set Column Width |
Alt OCW |
| Set Row Height |
Alt ORE |
| Column Standard Width |
Alt OCS |
| Group Rows or Columns |
Select rows or columns to be grouped, then Alt Shift Right Arrow |
| Ungroup Rows or Columns |
Select rows or columns to be ungrouped, then Alt Shift Left Arrow |
| Hide Rows |
Ctrl 9 |
| Hide Columns |
Ctrl 0 |
| Unhide Rows |
Ctrl Shift 9 |
| Unhide Columns |
Ctrl Shift 0 |
| |
|
| Before submitting |
|
| Spell Check |
F7 |
| Help |
F1 |