Spreadsheet: 104267d1301924707-learning-keyboard-shortcuts-for-excel-shortcut-keys
Sheet: Ctrl COMBINATIONS

Key | Description
[NAME]( | Unhides any hidden rows within the selection.
CTRL+) | Unhides any hidden columns within the selection.
CTRL+& | Applies the outline border to the selected cells.
CTRL+_ | Removes the outline border from the selected cells.
CTRL+~ | Applies the General number format.
CTRL+$ | Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% | Applies the Percentage format with no decimal places.
CTRL+^ | Applies the Exponential number format with two decimal places.
CTRL+# | Applies the Date format with the day, month, and year.
[NAME] | Applies the Time format with the hour and minute, and AM or PM.
CTRL+! | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+- | Displays the Delete dialog box to delete the selected cells.
CTRL+* | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
 | In a PivotTable, it selects the entire PivotTable report.
CTRL+: | Enters the current time.
CTRL+; | Enters the current date.
CTRL+` | Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+' | Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+" | Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ | Displays the [NAME] dialog box to insert blank cells.
CTRL+1 | Displays the Format Cells dialog box.
CTRL+2 | Applies or removes bold formatting.
CTRL+3 | Applies or removes italic formatting.
CTRL+4 | Applies or removes underlining.
CTRL+5 | Applies or removes strikethrough.
[NAME] | Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7 | Displays or hides the Standard toolbar.
CTRL+8 | Displays or hides the outline symbols.
CTRL+9 | Hides the selected rows.
CTRL+0 | Hides the selected columns.
CTRL+A | Selects the entire worksheet.
 | If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
 | When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
 | CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B | Applies or removes bold formatting.
CTRL+C | Copies the selected cells.
 | CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.
CTRL+D | Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F | Displays the [NAME] dialog box.
 | SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.
CTRL+G | Displays the Go To dialog box.
 | F5 also displays this dialog box.
CTRL+H | Displays the Find and Replace dialog box.
CTRL+I | Applies or removes italic formatting.
CTRL+K | Displays the [NAME] dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L | Displays the Create List dialog box.
CTRL+N | Creates a new, blank file.
CTRL+O | Displays the Open dialog box to open or find a file.
 | CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P | Displays the Print dialog box.
CTRL+R | Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S | Saves the active file with its current file name, location, and file format.
CTRL+U | Applies or removes underlining.
CTRL+V | Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
CTRL+W | Closes the selected workbook window.
CTRL+X | Cuts the selected cells.
CTRL+Y | Repeats the last command or action, if possible.
CTRL+Z | Uses the Undo command to reverse the last command or to delete the last entry you typed.
 | CTRL+SHIFT+Z uses the Undo or [NAME] command to reverse or restore the last automatic correction when AutoCorrect [NAME] are displayed.