|
Description
|
Shortcut Key |
| General |
| New file |
Ctrl + N |
| Open file |
Ctrl + O |
| Save file |
Ctrl + S |
| Move between open workbooks |
Ctrl + F6 |
| Close file |
Ctrl + F4 |
| Save as |
F12 |
| Display the print menu |
Ctrl + P |
| Select entire worksheet |
Ctrl + A |
| Insert a new worksheet |
Shift + F11 |
| Select column |
Ctrl + Space |
| Select row |
Shift + Space |
| Undo last action |
Ctrl + Z |
| Redo last action |
Ctrl + Y |
| Cut |
Ctrl + X |
| Copy |
Ctrl + C |
| Paste |
Ctrl + V |
| Find text |
Ctrl + F |
| Replace text dialog |
Ctrl + H |
| Edit a cell comment |
Shift + F2 |
| Delete one character to right |
Delete |
| Delete one character to left |
Backspace |
| Edit current cell |
F2 |
| Cancel cell entry |
Escape Key |
| Start a formula |
Equals Sign (e.g. SUM(A1+A2)) |
| Help |
F1 |
| Go to |
F5 |
| Exit Excel 97 |
Alt + F4 |
| Movement |
| Move to next cell in row |
Tab |
| Move to previous cell in row |
Shift + Tab |
| Up one screen |
Page Up |
| Down one screen |
Page Down |
| Move to next worksheet |
Ctrl + Page Down |
| Move to previous worksheet |
Ctrl + Page Up |
| Go to first cell in data region |
Ctrl + Home |
| Go to last cell in data region |
Ctrl + End |
| Formatting Text |
| Bold |
Ctrl + B |
| Italic |
Ctrl + I |
| Underline |
Ctrl + U |
| Strikethrough |
Ctrl + 5 |
| Change the font |
Ctrl + Shift + F |
| Change the font size |
Ctrl + Shift + P |
| Apply outline borders |
Ctrl + Shift + 7 |
| Remove all borders |
Ctrl + Shift + Underline |
| Wrap text in same cell |
Alt + Enter |
| Formatting Cells |
| Format cells |
Ctrl + 1 |
| Select font |
Ctrl + Shift + F |
| Select point size |
Ctrl + Shift + P |
| Format as currency |
Ctrl + Shift + 4 |
Format as general
(to remove any formatting) |
Ctrl + Shift + # (hash sign) |
| Format as percentage |
Ctrl + Shift + 5 |
| Format as number |
Ctrl + Shift + 1 |
| Highlighting Cells |
| Select entire worksheet |
Ctrl + A |
| Select entire row |
Shift + Spacebar |
| Select entire column |
Ctrl + Spacebar |
| Manual select |
Hold Shift + with Left, Right, Up, Down Arrow Key |
| Formulas |
| Auto sum a range of cells |
Alt + = |
| Insert current date |
Ctrl + ; |
| Insert current time |
Ctrl + Shift + ; |
| Insert columns/rows |
Ctrl + Shift + + |
| Miscellaneous |
| Create a chart automatically on new sheet |
F11 |
| Say Version of Excel |
Ctrl + Shift + V |
| Move to Next Sheet |
Ctrl + Page Down |
| Move to Prior Sheet |
Ctrl + Page Up |
| Go to a cell command |
Ctrl + G |
| Collapse Selection To Active Cell |
Shift + Backspace |
| Say Active Cell Coordinates |
Insert + C |
| AutoSum |
Alt + Equals |
| Formula Mode |
Equals Sign |
| Insert Date In Current Cell |
Ctrl + ; (semicolon) |
| Insert Time In Current Cell |
Ctrl + Shift + ; (semicolon) |
| Current Column First Cell From Top |
Alt + 1 |
| Current Column Second Cell From Top |
Alt + 2 |
| Current Column Third Cell From Top |
Alt + 3 |
| Current Column Fourth Cell From Top |
Alt + 4 |
| Data Region Left |
Ctrl + Left Arrow |
| Data Region Right |
Ctrl + Right Arrow |
| Data Region Down |
Ctrl + Down Arrow |
| Data Region Up |
Ctrl + Up Arrow |
| Select Whole Data Region |
Ctrl + Shift + 8 |
| Say Formula |
Ctrl + F2 |
| Spell Check |
F7 |
| Report Gridline Status |
Alt + Shift + g |
| Read Row Total |
Insert + Delete |
| Read Column Total |
Insert + Enter |
| Say Column Title |
Alt + Shift + C |
| Say Row Title |
Alt + Shift + R |
| Say Visible Range Coordinates |
Alt + Shift + V |
| Cycle Through Controls in Dialog Box |
Tab |
| Tab Backwards |
Shift + Tab |
| List Cells With Comments |
Ctrl + Shift + ' (apostrophe) |
| Row Second Cell From Left |
Alt + Ctrl + 2 |
| Row First Cell From Left |
Alt + Ctrl + 1 |
| Row Third Cell From Left |
Alt + Ctrl + 3 |
| Row Fourth Cell From Left |
Alt + Ctrl + 4 |
| Describe Cell Border |
Alt + Shift + B |
| Read Cell Comment |
Alt + Shift + ' (apostrophe) |
| Auto Filter |
Ctrl + Shift + A |
| Read Cell Hyperlink |
Alt + Shift + H |
| Close Office Assistant |
Ctrl + Insert + F4 |
| Set Monitor Cell One |
Alt + Ctrl + Shift + 1 |
| Set Monitor Cell Two |
Alt + Ctrl + Shift + 2 |
| Set Monitor Cell Three |
Alt + Ctrl + Shift + 3 |
| Set Monitor Cell Four |
Alt + Ctrl + Shift + 4 |
| Set Monitor Cell Five |
Alt + Ctrl + Shift + 5 |
| Set Monitor Cell Six |
Alt + Ctrl + Shift + 6 |
| Set Monitor Cell Seven |
Alt + Ctrl + Shift + 7 |
| Set Monitor Cell Eight |
Alt + Ctrl + Shift + 8 |
| Set Monitor Cell Nine |
Alt + Ctrl + Shift + 9 |
| Set Monitor Cell 10 |
Alt + Ctrl + Shift + 0 |
| Read Monitor Cell One |
Alt + Shift + 1 |
| Read Monitor Cell Two |
Alt + Shift + 2 |
| Read Monitor Cell Three |
Alt + Shift + 3 |
| Read Monitor Cell Four |
Alt + Shift + 4 |
| Read Monitor Cell Five |
Alt + Shift + 5 |
| Read Monitor Cell Six |
Alt + Shift + 6 |
| Read Monitor Cell Seven |
Alt + Shift + 7 |
| Read Monitor Cell Eight |
Alt + Shift + 8 |
| Read Monitor Cell Nine |
Alt + Shift + 9 |
| Read Monitor Cell Ten |
Alt + Shift + 0 |
| List Visible Cells With Data |
Ctrl + Shift + D |
| Lists Data In Current Column |
Ctrl + Shift + C |
| List Data In Current Row |
Ctrl + Shift + R |
| Select Hyperlink |
Ctrl + Shift + H |
| Move To Worksheet List box |
Ctrl + Shift + S |
| Move To Monitor Cell |
Ctrl + Shift + M |
| Select Worksheet Objects |
Ctrl + Shift + O |
| List Cells At Page Breaks |
Ctrl + Shift + B |
| Options List box |
Insert + V |