The keyboard shortcuts are helpful to work fast and productively.
| Category | Hold | Press | Keyword | Result |
| Format Data | Ctrl | 0 | column | Hide columns |
| Format Data | Ctrl | 1 | format | Display the Format Cells dialog box |
| Format Data | Ctrl + Shift | 2 | time | Apply Time format |
| Format Data | Ctrl | 5 | strikethrough | Apply or remove strikethrough formatting |
| Select Cells | Ctrl | 6 | object | Alternate between hiding objects, displaying objects, and displaying placeholders for objects |
| Select Cells | Ctrl | 7 | toolbar | Show or hide the Standard toolbar |
| Outline Data | Ctrl | 8 | outline | Display or hide outline symbols |
| Format Data | Ctrl | 9 | row | Hide rows |
| Enter Data | Ctrl | ' | copy | Copy formula from cell above |
| Format Data | Alt | ' | style | Style dialog box |
| Format Data | Ctrl + Shift | ' | number | Apply number format |
| Edit Data | Ctrl | - | delete | Delete selection |
| Format Data | Ctrl + Shift | - | border | Remove outline borders |
| Format Data | Ctrl + Shift | ! | number | Apply Number format with 2 decimal places, thousands separator |
| Enter Data | Ctrl + Shift | " | copy | Copy value from cell above |
| Format Data | Ctrl + Shift | # | date | Apply the Date format with the day, month, and year |
| Format Data | Ctrl + Shift | $ | currency | Apply Currency format |
| Format Data | Ctrl + Shift | % | percent | Apply Percentage format with no decimal places |
| Format Data | Ctrl + Shift | & | border | Apply the outline border |
| Format Data | Ctrl + Shift | ( | row | Unhide rows |
| Format Data | Ctrl + Shift | ) | column | Unhide columns |
| Select Cells | Ctrl + Shift | * | region | Select the current region |
| Move within Selection | Ctrl | . | move | Move clockwise to the next corner of the selection |
| Select Cells | Ctrl | / | array | Select current array |
| Enter Data | Ctrl + Shift | ; | time | Enter the time |
| Enter Data | Ctrl | ; | date | Enter the date |
| Select Cells | Alt | ; | cells | Select visible cells in current selection |
| Select Cells | Ctrl | [ | dependent | Select direct dependents |
| Select Cells | Ctrl + Shift | [ | dependent | Select all dependents |
| Select Cells | Ctrl | \ | difference | Select differences |
| Select Cells | Ctrl + Shift | \ | unequal | Select unequal cells |
| Select Cells | Ctrl | ] | precedent | Select direct precedents |
| Select Cells | Ctrl + Shift | ] | precedent | Select all precedents |
| Format Data | Ctrl + Shift | ^ | number | Apply Exponential number format |
| Enter Data | Ctrl | ` | formula | Toggle formula view |
| Edit Data | Ctrl + Shift | = | insert | Insert blank cells |
| Enter Data | Alt | = | AutoSum | Insert the AutoSum formula |
| Enter Data | Ctrl | A | formula | Display Formula Palette after typing function name in formula |
| Enter Data | Ctrl + Shift | A | formula | Insert the argument names and parentheses for a function after you type a function name in a formula |
| Select Cells | Ctrl | A | All | Select the entire worksheet |
| Enter Data | Arrow key | move | Move one character up, down, left, or right | |
| Move and Scroll | Ctrl | Arrow key | move | Move to edge of current region |
| Move and Scroll | Arrow key | move | Move one cell up, down, left, or right | |
| Select Cells | Ctrl + Shift | Arrow Key | select | Extend the selection to the last nonblank cell in the same column or row as the active cell |
| Select Cells | Shift | Arrow Key | select | Extend the selection by one cell |
| Format Data | Ctrl | B | bold | Apply or remove bold formatting |
| Enter Data | Backspace | delete | Delete character to left of insertion point, or delete selection | |
| Move and Scroll | Ctrl | Backspace | scroll | Scroll to display the active cell |
| Select Cells | Shift | Backspace | select | Select only the active cell when multiple cells are selected |
| Edit Data | Ctrl | C | copy | Copy the selection |
| Enter Data | Ctrl | D | fill | Fill down |
| Enter Data | Ctrl | Delete | delete | Delete text to the end of the line |
| Enter Data | Delete | delete | Delete character to right of insertion point, or delete selection | |
| Enter Data | Alt | Down Arrow | AutoComplete | Display the AutoComplete list |
| Move and Scroll | Ctrl | End | move | Move to the last cell on the worksheet |
| Select Cells | Ctrl + Shift | End | select | Extend the selection to the last used cell on the worksheet (lower-right corner) |
| Enter Data | Alt | Enter | line break | Start a new line in the same cell |
| Enter Data | Ctrl | Enter | fill | Fill the selected cell range with current entry |
| Enter Data | Ctrl + Shift | Enter | array | Enter formula as array formula |
| Enter Data | Shift | Enter | complete | Complete cell entry and move up in selection |
| Enter Data | Enter | complete | Complete cell entry and move down in selection | |
| Enter Data | Esc | cancel | Cancel a cell entry | |
| Menus | Esc | close | Close visible menu or submenu | |
| Windows | Ctrl | Esc | Start | Show the Windows Start menu |
| Help | F1 | Help | Open the Help Task pane | |
| Menus | Shift | F10 | shortcut | Show a shortcut menu |
| Menus | F10 | menu | Make the menu bar active | |
| Windows | Ctrl | F10 | maximize | Maximize or restore the workbook window |
| Charts | F11 | chart | Create a chart that uses the current range | |
| Macros | Alt | F11 | VBE | Display the Visual Basic Editor |
| Macros | Ctrl | F11 | macro | Insert a Microsoft Excel 4.0 macro sheet |
| Worksheets | Shift | F11 | worksheet | Insert a new worksheet |
| Workbook | Ctrl | F12 | open | Display the Open dialog box |
| Workbook | F12 | save as | Open the Save As dialog box | |
| Workbook | Shift | F12 | save | Save the file |
| Ctrl + Shift | F12 | Display the Print dialog box | ||
| Charts | Alt | F2 | chart | Create a chart that uses the current range |
| Enter Data | Shift | F2 | comment | Edit a cell comment |
| Enter Data | F2 | edit | Edit the active cell and position the insertion point at the end of the line | |
| Worksheets | Alt + Shift | F2 | worksheet | Insert a new worksheet |
| Enter Data | Ctrl | F3 | name | Define a name |
| Enter Data | Ctrl + Shift | F3 | name | Create names from row and column labels |
| Enter Data | Shift | F3 | function | Paste a function into a formula |
| Enter Data | F3 | name | Paste defined name into formula | |
| Enter Data | F4 | repeat | Repeat the last action | |
| Move and Scroll | Shift | F4 | find | Repeat the last Find action (Find Next) |
| Windows | Ctrl | F4 | close | Close the active workbook window |
| Move and Scroll | Shift | F5 | find | Display the Find dialog box |
| Move and Scroll | F5 | go to | Display the Go To dialog box | |
| Windows | Ctrl | F5 | restore | Restore the active workbook window size |
| Dialog Box | F6 | dialog box | In a range selection box, switch focus to the worksheet | |
| Move and Scroll | Ctrl | F6 | window | Move to the next workbook or window |
| Move and Scroll | Ctrl+Shift | F6 | window | Move to the previous workbook or window |
| Move and Scroll | Shift | F6 | pane | Move to previous pane in workbook that has been split |
| Move and Scroll | F6 | pane | Move to next pane in split workbook | |
| Edit Data | F7 | spell | Display the Spelling dialog box | |
| Windows | Ctrl | F7 | move | Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window |
| Macros | Alt | F8 | macro | Display the Macro dialog box |
| Select Cells | Shift | F8 | select | Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |
| Select Cells | F8 | select | Turn on extending a selection by using the arrow keys | |
| Windows | Ctrl | F8 | size | Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window |
| Enter Data | Ctrl + Alt | F9 | calculate | Calculate all sheets in the active workbook |
| Enter Data | Shift | F9 | calculate | Calculate the active worksheet |
| Enter Data | F9 | calculate | Calculate all sheets in all open workbooks | |
| Windows | Ctrl | F9 | minimize | Minimize the workbook window to an icon |
| Move and Scroll | Ctrl | Home | move | Move to the beginning of the worksheet |
| Move and Scroll | Home | move | Move to the beginning of the row | |
| Select Cells | Ctrl + Shift | Home | select | Extend the selection to the beginning of the worksheet |
| Select Cells | Shift | Home | select | Extend the selection to the beginning of the row |
| Format Data | Ctrl | I | italic | Apply or remove italic formatting |
| Enter Data | Ctrl | K | hyperlink | Insert a hyperlink |
| Move within Selection | Ctrl + Alt | Left Arrow | move | Move left between nonadjacent selections |
| Outline Data | Alt + Shift | Left Arrow | group | Ungroup rows or columns |
| Select Cells | Ctrl + Shift | O | comment | Select all cells with comments |
| Ctrl | P | Display the Print dialog box | ||
| Move and Scroll | Alt | Page Down | move | Move one screen to the right |
| Move and Scroll | Ctrl | Page Down | move | Move to the next sheet in the workbook |
| Move and Scroll | Page Down | move | Move down one screen | |
| Select Cells | Shift | Page Down | select | Extend the selection down one screen |
| Worksheets | Ctrl + Shift | Page Down | select | Select current and next sheet in workbook |
| Move and Scroll | Alt | Page Up | move | Move one screen to the left |
| Move and Scroll | Ctrl | Page Up | move | Move to the previous sheet in the workbook |
| Move and Scroll | Page Up | move | Move up one screen | |
| Select Cells | Shift | Page Up | select | Extend the selection up one screen |
| Worksheets | Ctrl + Shift | Page Up | select | Select current and previous in workbook |
| Windows | Alt | Print Screen | copy | Copy the image of the active window to the Clipboard |
| Windows | Print Screen | copy | Copy the image of the screen to the Clipboard | |
| Enter Data | Ctrl | R | fill | Fill to the right |
| Move within Selection | Ctrl + Alt | Right Arrow | move | Move right between nonadjacent selections |
| Outline Data | Alt + Shift | Right Arrow | group | Group rows or columns |
| Menus | Alt | Spacebar | menu | Show control menu |
| Select Cells | Ctrl | Spacebar | column | Select the entire column |
| Select Cells | Ctrl + Shift | Spacebar | objects | With an object selected, select all objects on a sheet |
| Select Cells | Shift | Spacebar | row | Select the entire row |
| Move and Scroll | Ctrl | Tab | window | Move to the next workbook or window |
| Move and Scroll | Ctrl+Shift | Tab | window | Move to the previous workbook or window |
| Move within Selection | Shift | Tab | left | Move left |
| Move within Selection | Tab | right | Move right | |
| Windows | Alt | Tab | program | Switch to the next program |
| Windows | Alt + Shift | Tab | program | Switch to the previous program |
| Format Data | Ctrl | U | underline | Apply or remove an underline |
| Edit Data | Ctrl | V | paste | Paste the selection |
| Windows | Ctrl | W | close | Close the active workbook window |
| Edit Data | Ctrl | X | cut | Cut the selection |
| Enter Data | Ctrl | Y | repeat | Repeat the last action |
| Edit Data | Ctrl | Z | undo | Undo the last action |
No comments:
Post a Comment