Extend Selection
| What It Does | Key(s) |
| 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
| What It Does | Key(s) |
| 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
| What It Does | Key(s) |
| 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+_ |