| Shortcut key | Action |
|---|
| Ctrl+A | Select All |
| Ctrl+B | Bold |
| Ctrl+C | Copy |
| Ctrl+D | Fill Down |
| Ctrl+E | Flash Fill |
| Ctrl+F | Find |
| Ctrl+G | Goto |
| Ctrl+H | Replace |
| Ctrl+I | Italic |
| Ctrl+K | Insert Hyperlink |
| Ctrl+N | New Workbook |
| Ctrl+O | Open |
| Ctrl+P | Print |
| Ctrl+R | Fill Right |
| Ctrl+S | Save |
| Ctrl+U | Underline |
| Ctrl+V | Paste |
| Ctrl W | Close |
| Ctrl+X | Cut |
| Ctrl+Y | Repeat |
| Ctrl+Z | Undo |
| F1 | Help |
| F2 | Edit |
| F3 | Paste Name |
| F4 | Repeat last action |
| F4 | While typing a formula, switch between absolute/relative refs |
| F5 | Goto |
| F6 | Next Pane |
| F7 | Spell check |
| F8 | Extend mode |
| F9 | Recalculate all workbooks |
| F10 | Activate Menubar |
| F11 | New Chart |
| F12 | Save As |
| Ctrl+: | Insert Current Time |
| Ctrl+; | Insert Current Date |
| Ctrl+" | Copy Value from Cell Above |
| Ctrl+’ | Copy Formula from Cell Above |
| Shift | Hold down shift for additional functions in Excel’s menu |
| Shift+F1 | What’s This? |
| Shift+F2 | Edit cell comment |
| Shift+F3 | Paste function into formula |
| Shift+F4 | Find Next |
| Shift+F5 | Find |
| Shift+F6 | Previous Pane |
| Shift+F8 | Add to selection |
| Shift+F9 | Calculate active worksheet |
| Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| Shift+F10 | Display shortcut menu
Shortcut key | Action |
|---|
| F1 | Help | | F2 | View Object Browser | | F3 | Find Next | | F4 | Properies Window | | F5 | Run Sub/Form or Run Macro | | F6 | Switch Split Windows | | F7 | View Code Window | | F8 | Step Into | | F9 | Toggle Breakpoint | | F10 | Activate Menu Bar | | Shift+F2 | View definition | | Shift+F3 | Find Previous | | Shift+F7 | View Object | | Shift+F8 | Step Over | | Shift+F9 | Quick Watch | | Shift+F10 | Show Right Click Menu | | Ctrl+F2 | Focus To Object Box | | Ctrl+F4 | Close Window | | Ctrl+F8 | Run To Cursor | | Ctrl+F10 | Activate Menu Bar | | Alt+F4 | Close VBE | | Alt+F6 | Switch Between Last 2 Windows | | Alt+F11 | Return To Application | | Ctrl+Shift+F2 | Go to last position | | Ctrl+Shift+F8 | Step Out | | Ctrl+Shift+F9 | Clear All Breakpoints | | Insert | Toggle Insert Mode | | Delete | Delete | | Home | Move to beginning of line | | End | Move to end of line | | Page Up | Page Up | | Page Down | Page Down | | Left Arrow | Left | | Right Arrow | Right | | Up Arrow | Up | | Down Arrow | Down | | Tab | Indent | | Enter | New Line | | BackSpace | Delete Prev Char | | Shift+Insert | Paste | | Shift+Home | Select To Start Of Line | | Shift+End | Select To End Of Line | | Shift+Page Up | Select To Top Of Module | | Shift+Page Down | Select To End Of Module | | Shift+Left Arrow | Extend Selection Left 1 Char | | Shift+Right Arrow | Extend Selection Right 1 Char | | Shift+Up Arrow | Extend Selection Up | | Shift+Down Arrow | Extend Selection Down | | Shift+Tab | Outdent | | Alt+Spacebar | System Menu | | Alt+Tab | Cycle Applications | | Alt+BackSpace | Undo | | Ctrl+A | Select All | | Ctrl+C | Copy | | Ctrl+E | Export Module | | Ctrl+F | Find | | Ctrl+G | Immediate Window | | Ctrl+H | Replace | | Ctrl+I | Turn On Quick Info | | Ctrl+J | List Properties/Methods | | Ctrl+L | Show Call Stack | | Ctrl+M | Import File | | Ctrl+N | New Line | | Ctrl+P | Print | | Ctrl+R | Project Explorer | | Ctrl+S | Save | | Ctrl+T | Show Available Components | | Ctrl+V | Paste | | Ctrl+X | Cut | | Ctrl+Y | Cut Entire Line | | Ctrl+Z | Undo | | Ctrl+Insert | Copy | | Ctrl+Delete | Delete To End Of Word | | Ctrl+Home | Top Of Module | | Ctrl+End | End Of Module | | Ctrl+Page Up | Top Of Current Procedure | | Ctrl+Page Down | End Of Current Procedure | | Ctrl+Left Arrow | Move one word to left | | Ctrl+Right Arrow | Move one word to right | | Ctrl+Up Arrow | Previous Procedure | | Ctrl+Down Arrow | Next Procedure | | Ctrl+Spacebar | Complete Word | | Ctrl+Tab | Cycle Windows | | Ctrl+BackSpace | Delete To Start Of Word | | Ctrl+Break/Pause | Break | | Ctrl+Shift+I | Parameter Info | | Ctrl+Shift+J | List Constants |
|
Comments
Post a Comment