| Excel Shortcuts | Result |
|---|
| CTRL+- | Delete cell/row/column menu. |
| CTRL+' (APOSTROPHE) | Fill cell formulas down and edit (copy above cell formulas). |
| CTRL+- WITH ROW / COLUMN SELECTED | Delete row / delete column. |
| CTRL+" | Fill cell values down and edit (copy above cell values). |
| CTRL+. (PERIOD) | Move clockwise to the next corner of the selection. |
| CTRL+; (SEMICOLON) | Insert current date. |
| CTRL+` (GRAVE ACCENT) | Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark. |
| CTRL+0 (ZERO) | Hide the selected columns. |
| CTRL+1 | Format cells dialog. |
| CTRL+1, THEN CTRL+ARROW RIGHT/ARROW LEFT | Access border menu in 'format cell' dialog. Once border was selected, it will show up directly on the next ctrl+1. |
| CTRL+5 | Apply or remove strikethrough formatting. |
| CTRL+6 | Alternate between hiding and displaying objects. |
| CTRL+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| CTRL+8 | Display or hides the outline symbols. |
| CTRL+9 | Hide the selected rows. |
| CTRL+A | Display formula window after typing formula name. |
| CTRL+A (OR CTRL+SHIFT+SPACEBAR) | Select the entire worksheet or the data-containing area. Pressing "ctrl+a" a second time then selects entire worksheet. |
| CTRL+ALT+ARROW RIGHT/CTRL+ALT+ARROW LEFT | Move to the right / to the left between non-adjacent selections (with multiple ranges selected). |
| CTRL+ALT+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| CTRL+ALT+SHIFT+F9 | Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| CTRL+ALT+V | If data exists in clipboard: display the paste special dialog box. |
| CTRL+ARROW KEYS | Move to the edge of next data region (cells that contains data). |
| CTRL+ARROW LEFT/CTRL+ARROW RIGHT | Inside a cell: move one word to the left / to the right. |
| CTRL+B (OR CTRL+2) | Apply or remove bold formatting. |
| CTRL+BACKSPACE | Show active cell within selection. |
| CTRL+C | Copy contents of selected cells. |
| CTRL+D | Fill complete cell down (copy above cell). |
| CTRL+DELETE | Delete text to the end of the line. |
| CTRL+END | Move to the last cell with content on a worksheet. |
| CTRL+F | Display the find and replace dialog box (with find selected). |
| CTRL+F1 | Select the active tab of the ribbon and activate the access keys. Press either of these keys again to move back to the document and cancel the access keys. And then arrow left or arrow right. |
| CTRL+F10 | Move workbook windows which are not maximized. |
| CTRL+F3 | Create names from row and column labels. |
| CTRL+F4 | Create a new blank workbook (excel file). |
| CTRL+F7 | Perform size command for workbook windows which are not maximzed. |
| CTRL+F8 | Close excel. |
| CTRL+F9 | Maximize or restores the selected workbook window. |
| CTRL+G (OR F5) | Display the 'go to' dialog box. |
| CTRL+H | Display the find and replace dialog box (with replace selected). |
| CTRL+HOME | Move to the beginning of a worksheet. |
| CTRL+I (OR CTRL+3) | Apply or remove italic formatting. |
| CTRL+K | Insert a hyperlink. |
| CTRL+L | Insert a table (display create table dialog box). |
| CTRL+N | Move to next / previous workbook window. |
| CTRL+O | Save the active file with its current file name, location, and file format. |
| CTRL+P | Display the excel help task pane. |
| CTRL+PAGE DOWN | Move to the first record. |
| CTRL+PAGE DOWN/CTRL+PAGE UP | Select the current and next sheet(s) / select and previous sheet(s). |
| CTRL+PAGE UP | Move to the beginning / end of a field. |
| CTRL+R | Fill complete cell to the right (copy cell from the left). |
| CTRL+S | Display the save as dialog box. |
| CTRL+SHIFT+! | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| CTRL+SHIFT+# | Apply the date format with the day, month, and year. |
| CTRL+SHIFT+$ | Apply the currency format with two decimal places. |
| CTRL+SHIFT+% | Apply the percentage format with no decimal places. |
| CTRL+SHIFT+& | Apply outline border from cell or selection. |
| CTRL+SHIFT+* (ASTERISK) | Display the list for the current field in a pivottable report. |
| CTRL+SHIFT+* (ASTERISK) | Select the current region around the active cell. |
| CTRL+SHIFT+: (COLON) | Insert current time. |
| CTRL+SHIFT+@ | Apply the time format with the hour and minute, and indicate a.m. Or p.m. |
| CTRL+SHIFT+[+] | If data exists in clipboard: display the insert dialog box to insert blank cells. |
| CTRL+SHIFT+^ | Apply the scientific number format with two decimal places. |
| CTRL+SHIFT+_ (UNDERSCORE) | Remove outline borders from cell or selection. |
| CTRL+SHIFT+~ | Apply the general number format.. |
| CTRL+SHIFT+ | Display order menu for insert cell/row and column. |
| CTRL+SHIFT+ WITH ROW SELECTED | Insert row |
| CTRL+SHIFT+ WITH COLUMN SELECTED | Insert column. |
| CTRL+SHIFT+0 (ZERO) | Unhide any hidden columns within the selection*. |
| CTRL+SHIFT+9 | Unhide any hidden rows within the selection. |
| CTRL+SHIFT+A | Insert arguments in formula after typing formula name. |
| CTRL+SHIFT+ARROW KEY | Extend the selection to the last cell with content in row or column. |
| CTRL+SHIFT+ARROW LEFT/CTRL+SHIFT+ARROW RIGHT | Select or unselect one word to the left / to the right. |
| CTRL+SHIFT+END | Extend the selection to the last used cell on the worksheet (lower-right corner). |
| CTRL+SHIFT+ENTER | Enter a formula as an array formula. |
| CTRL+SHIFT+F | Display the format cells with fonts tab active. Press tab 3x to get to font-size. Used to bectrl+shift+p, but that seems just get to the font tab in 2010. |
| CTRL+SHIFT+F3 | Paste a defined name into a formula. |
| CTRL+SHIFT+HOME | Extend the selection to the beginning of the worksheet. |
| CTRL+SHIFT+O | Select all cells with comments. |
| CTRL+SHIFT+PAGE UP | Select the current and previous sheet in a workbook. |
| CTRL+SHIFT+U | Toggle expand or collapse formula bar. |
| CTRL+SPACE | Select the entire column. |
| CTRL+TAB CTRL+SHIFT+TAB | On a field button: select the area you want to move the selected field to. |
| CTRL+TAB/CTRL+SHIFT+TAB | Display the control menu for main excel window. |
| CTRL+TAB/CTRL+SHIFT+TAB | In a dialog box: perform the action for the selected button, or select/clear a check box. |
| CTRL+U (OR CTRL+4) | Apply or remove an underline. |
| CTRL+V | Paste content from clipboard into selected cell. |
| CTRL+X | Cut contents of selected cells. |
| CTRL+Y | Redo last action (multiple levels). |
| CTRL+Z | Undo last action (multiple levels). |
.png)
.png)
+(1).png)
