| General Commands | |
| Get help | F1 |
| Activate menu bar | F10 |
| Find an entry | Shift+F5 |
| Repeat most recent find operation | Shift+F4 |
| Check spelling | F7 |
| Workbook File Commands | |
| Create new file | Ctrl+N |
| Open file | Ctrl+O |
| Print file | Ctrl+P |
| Save file | Ctrl+S |
| Save copy of file under another name | F12 |
| Navigate Worksheets | |
| Move one cell up, down, left, or right | Arrow Keys |
| Go to active cell | Ctrl+Backspace |
| Move to next unlocked cell on a protected worksheet | Tab |
| Move down one screen | Page Down |
| Move up one screen | Page Up |
| Move one screen to the right | Alt+Page Down |
| Move one screen to the left | Alt+Page Up |
| Switch to next split pane | F6 |
| Switch to previous split pane | Shift+F6 |
| Find text or format | Ctrl+F |
| Flip to next worksheet page | Ctrl+Page Down |
| Flip to previous worksheet page | Ctrl+Page Up |
| Go to a specific cell or named range | F5 or Ctrl+G |
| Move to edge of current data region | Ctrl+Arrow Key |
| Move to beginning of row | Home |
| Move to beginning of worksheet | Ctrl+Home |
| Move to last cell on worksheet | Ctrl+End |
| Navigate in Selected Range | |
| Move from top to bottom of range | Enter |
| Move from bottom to top of range | Shift+Enter |
| Move from left to right of range | Tab |
| Move from right to left of range | Shift+Tab |
| Move clockwise to next corner of range | Ctrl+Period |
| Switch to selected range to the right | Ctrl+Alt+Right Arrow |
| Switch to selected range to the left | Ctrl+Alt+Left Arrow |
| Navigate in End Mode | |
| Toggle End mode on or off | End |
| Move to next data block in row or column | End+Arrow Key |
| Move down and to the right to the last used worksheet cell | End+Home |
| Move to rightmost used cell in current row | End+Enter |
| Navigate with Scroll Lock | |
| Toggle Scroll Lock on or off | Scroll Lock |
| Select cell in upper-left corner of window | Home |
| Select cell in lower-right corner of window | End |
| Scroll one row up | Up Arrow |
| Scroll one row down | Down Arrow |
| Scroll one column to left | Left Arrow |
| Scroll one column to right | Right Arrow |
| Data Entry | |
| End cell entry and move down one cell | Enter |
| End cell entry and move up one cell | Shift+Enter |
| End cell entry and move one cell to right | Tab |
| End cell entry and move one cell to left | Shift+Tab |
| Cancel an entry you typed | Esc |
| Move one character or line left, right, up, or down when entering or editing cell entry | Arrow Key |
| Move to beginning of entry | Home |
| Fill a cell entry into cells below | Ctrl+D |
| Fill a cell entry into cells to right | Ctrl+R |
| Fill range with current entry | Ctrl+Enter |
| Paste a function into a formula | Shift+F3 |
| Insert AutoSum formula | Alt+= (equal sign) |
| Start new line in cell entry | Alt+Enter (when typing or editing entry) |
| Insert page break | Alt+Enter (when cell, row, or column is selected) |
| Insert date | Ctrl+; (semicolon) |
| Insert time | Ctrl+: ( colon ) |
| Insert new worksheet | Shift+F11 |
| Select entry from a drop-down list of entries already typed in a row or column | Alt+Down Arrow |
| Insert hyperlink (for Web-based worksheets) | Ctrl+K |
| Formula/Function Entry | |
| Start formula entry | = (equal sign) |
| Enter a formula as an array formula | Ctrl+Shift+Enter |
| Display Insert Function dialog box when typing or editing a formula | Shift+F3 |
| Display Function Arguments dialog box when insertion point is to right of function name in formula | Ctrl+A |
| Insert argument names and parentheses when insertion point is to right of function name in formula | Ctrl+Shift+A |
| Paste range name into formula | F3 |
| Insert AutoSum formula with SUM function | Alt+= (equal sign) |
| Copy value from cell above active cell into active cell | Ctrl+Shift+" (quotation mark) |
| Copy formula from cell above active cell into active cell | Ctrl+' (apostrophe) |
| Toggle display of cell values and formulas | Ctrl+` (single left quotation mark) |
| Recalculate all formulas or selected portion of current formula | F9 |
| Calculate only the active worksheet | Shift+F9 |
| Recalculate all formulas whether or not they have changed since the last calculation | Ctrl+Alt+F9 |
| Check all dependent formulas and recalculate all formulas, including those not marked for recalculation | Ctrl+Alt+Shift+F9 |
| Selection Keystrokes | |
| Select cell | Arrow Keys |
| Name selected range of cells | Ctrl+F3 |
| Name range using an entry from a cell in the range | Ctrl+Shift+F3 |
| Select entire column | Ctrl+Spacebar |
| Select entire row | Shift+Spacebar |
| Select entire worksheet | Ctrl+A |
| Deselect all but the active cell | Shift+Backspace |
| Select all objects on worksheet when an object is selected | Ctrl+Shift+Spacebar |
| Toggle between hiding or displaying objects or displaying placeholders for objects | Ctrl+6 |
| Select current and next worksheet | Ctrl+Shift+Page Down |
| Select current and previous worksheet | Ctrl+Shift+Page Up |
| Deselect multiple worksheets | Ctrl+Page Down |
| Extend Selection | |
| Toggle Extend mode on or off | F8 |
| Extend selection in Extend mode | Arrow Key |
| Select another range | Shift+F8 |
| Extend selection with Extend mode off | Shift+Arrow Key |
| Extend selection to last used cell | Ctrl+Shift+Arrow Key |
| Extend selection to beginning of row | Shift+Home |
| Extend selection to beginning of worksheet | Ctrl+Shift+Home |
| Extend selection to last used cell | Ctrl+Shift+End |
| Extend selection down one screen | Shift+Page Down |
| Extend selection up one screen | Shift+Page Up |
| Extend selection to last used cell in same column or row | End+Shift+Arrow Key |
| Extend selection to last used cell | End+Shift+Home |
| Extend selection to last cell in current row | End+Shift+Enter |
| Extend selection to cell in upper-left corner of window | Scroll Lock+Shift+Home |
| Extend selection to cell in lower-right corner of window | Scroll Lock+Shift+End |
| Editing Shortcuts | |
| Copy selection | Ctrl+C |
| Display Office Clipboard | Ctrl+C, Ctrl+C |
| Replace text | Ctrl+H |
| Paste selection | Ctrl+V |
| Cut selection | Ctrl+X |
| Repeat last action | Ctrl+Y or F4 |
| Undo last action | Ctrl+Z |
| Delete entries in selected cells | Delete |
| Delete character to the right of the insertion point when in Edit mode | Delete |
| Delete from the insertion point to the end of the line | Ctrl+Delete |
| Delete character to the left of the insertion point when in Edit mode | Backspace |
| Delete cells | Ctrl+- (hyphen) |
| Insert blank cells | Ctrl+Shift++ (plus sign) |
| Edit a cell entry | F2 |
| Edit a cell comment | Shift+F2 |
| Rename current worksheet | ALT+O H R |
| Move or copy current worksheet | ALT+E M |
| Delete current worksheet | ALT+E L |
| Formatting Shortcuts | |
| Copy format of selection | Ctrl+Shift+C |
| Paste format | Ctrl+Shift+V |
| Display Style dialog box | Alt+' (apostrophe) |
| Display Format Cells dialog box | Ctrl+1 |
| Apply General Number format | Ctrl+Shift+~ |
| Apply Currency format | Ctrl+Shift+$ |
| Apply Percentage format | Ctrl+Shift+% |
| Apply Exponential Number format | Ctrl+Shift+^ |
| Apply Date format | Ctrl+Shift+# |
| Apply Time format | Ctrl+Shift+@ |
| Apply the Number format with two decimal places, thousands separator, and minus sign ( “) for negative values | Ctrl+Shift+! |
| Add or remove boldfacing | Ctrl+B |
| Add or remove italics | Ctrl+I |
| Add or remove underlining | Ctrl+U |
| Add or remove strikethrough | Ctrl+5 |
| Hide selected rows | Ctrl+9 |
| Unhide any hidden rows in selection | Ctrl+Shift+( (opening parenthesis) |
| Hide selected columns | Ctrl+0 (zero) |
| Unhide any hidden columns in selection | Ctrl+Shift+) (closing parenthesis) |
| Apply outline border around selected cells | Ctrl+Shift+& |
| Remove outline border from around selected cells | Ctrl+Shift+_ |
