CTRL+SHIFT+( <--Excel shortcut--> Unhides any hidden rows within the selection.
CTRL+SHIFT+& <--Excel shortcut--> Applies the outline border to the selected cells.
CTRL+SHIFT_ <--Excel shortcut--> Removes the outline border from the selected cells.
CTRL+SHIFT+~ <--Excel shortcut--> Applies the General number format.
CTRL+SHIFT+$ <--Excel shortcut--> Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+% <--Excel shortcut--> Applies the Percentage format with no decimal places.
CTRL+SHIFT+^ <--Excel shortcut--> Applies the Scientific number format with two decimal places.
CTRL+SHIFT+# <--Excel shortcut--> Applies the Date format with the day, month, and year.
CTRL+SHIFT+@ <--Excel shortcut--> Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+( <--Excel shortcut--> Unhides any hidden rows within the selection.
CTRL+SHIFT+& <--Excel shortcut--> Applies the outline border to the selected cells.
CTRL+SHIFT_ <--Excel shortcut--> Removes the outline border from the selected cells.
CTRL+SHIFT+~ <--Excel shortcut--> Applies the General number format.
CTRL+SHIFT+$ <--Excel shortcut--> Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+% <--Excel shortcut--> Applies the Percentage format with no decimal places.
CTRL+SHIFT+^ <--Excel shortcut--> Applies the Scientific number format with two decimal places.
CTRL+SHIFT+# <--Excel shortcut--> Applies the Date format with the day, month, and year.
CTRL+SHIFT+@ <--Excel shortcut--> Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+! <--Excel shortcut--> Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+* <--Excel shortcut--> Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
<--Excel shortcut--> In a PivotTable, it selects the entire PivotTable report.
CTRL+SHIFT+: <--Excel shortcut--> Enters the current time.
CTRL+SHIFT+" <--Excel shortcut--> Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+) <--Excel shortcut--> Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-) <--Excel shortcut--> Displays the Delete dialog box to delete the selected cells.
CTRL+; <--Excel shortcut--> Enters the current date.
CTRL+` <--Excel shortcut--> Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+' <--Excel shortcut--> Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1 <--Excel shortcut--> Displays the Format Cells dialog box.
CTRL+2 <--Excel shortcut--> Applies or removes bold formatting.
CTRL+3 <--Excel shortcut--> Applies or removes italic formatting.
CTRL+4 <--Excel shortcut--> Applies or removes underlining.
CTRL+5 <--Excel shortcut--> Applies or removes strikethrough.
CTRL+6 <--Excel shortcut--> Alternates between hiding and displaying objects.
CTRL+8 <--Excel shortcut--> Displays or hides the outline symbols.
CTRL+9 <--Excel shortcut--> Hides the selected rows.
CTRL+0 <--Excel shortcut--> Hides the selected columns.
CTRL+A <--Excel shortcut--> Selects the entire worksheet.
<--Excel shortcut--> If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
<--Excel shortcut--> When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
<--Excel shortcut--> 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 <--Excel shortcut--> Applies or removes bold formatting.
CTRL+C <--Excel shortcut--> Copies the selected cells.
CTRL+D <--Excel shortcut--> 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 <--Excel shortcut--> Displays the Find and Replace dialog box, with the Find tab selected.
<--Excel shortcut--> SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
<--Excel shortcut--> CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G <--Excel shortcut--> Displays the Go To dialog box.
<--Excel shortcut--> F5 also displays this dialog box.
CTRL+H <--Excel shortcut--> Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+I <--Excel shortcut--> Applies or removes italic formatting.
CTRL+K <--Excel shortcut--> Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L <--Excel shortcut--> Displays the Create Table dialog box.
CTRL+N <--Excel shortcut--> Creates a new, blank workbook.
CTRL+O <--Excel shortcut--> Displays the Open dialog box to open or find a file.
<--Excel shortcut--> CTRL+SHIFT+O selects all cells that contain comments.
CTRL+P <--Excel shortcut--> Displays the Print tab in Microsoft Office Backstage view.
<--Excel shortcut--> CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R <--Excel shortcut--> 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 <--Excel shortcut--> Saves the active file with its current file name, location, and file format.
CTRL+T <--Excel shortcut--> Displays the Create Table dialog box.
CTRL+U <--Excel shortcut--> Applies or removes underlining.
<--Excel shortcut--> CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V <--Excel shortcut--> Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
<--Excel shortcut--> CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W <--Excel shortcut--> Closes the selected workbook window.
CTRL+X <--Excel shortcut--> Cuts the selected cells.
CTRL+Y <--Excel shortcut--> Repeats the last command or action, if possible.
CTRL+Z <--Excel shortcut--> Uses the Undo command to reverse the last command or to delete the last entry that you typed.
All keyboard shortcuts in Excel , Learn All keyboard shortcuts in Excel, Learn All Excel shortcuts, Learn All keyboard Excel shortcuts
