CTRL combination shortcut keys

CTRL combination shortcut keys
Key                                          »»» Description
CTRL+SHIFT+(  »»» Unhides any hidden rows within the selection.
CTRL+SHIFT+)   »»» Unhides any hidden columns within the selection.
CTRL+SHIFT+&   »»» Applies the outline border to the selected cells.
CTRL+SHIFT_   »»» Removes the outline border from the selected cells.
CTRL+SHIFT+~   »»» Applies the General number format.
CTRL+SHIFT+$   »»» Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%   »»» Applies the Percentage format with no decimal places.
CTRL+SHIFT+^   »»» Applies the Exponential number format with two decimal places.
CTRL+SHIFT+#   »»» Applies the Date format with the day,  month,  and year.
CTRL+SHIFT+@   »»» Applies the Time format with the hour and minute,  and AM or PM.
CTRL+SHIFT+!   »»» Applies the Number format with two decimal places,  thousands separator,  and minus sign (-) for negative values.
CTRL+SHIFT+*       »»» 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+SHIFT+:    »»» Enters the current time.
CTRL+SHIFT+"     »»» Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus (+)  »»» Displays the  Insert  dialog box to insert blank cells.
CTRL+Minus (-)  »»» Displays the  Delete  dialog box to delete the selected cells.
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+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.
CTRL+6  »»» Alternates between hiding objects  displaying objects  and displaying placeholders for objects.
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 current region and its summary rows. Pressing CTRL+A a third 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 Clipboard.
CTRL+D  »»» ses 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             Find and Replace  dialog box  with the  Find  tab selected.
SHIFT+F5 also displays this tab  while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with theFont tab selected.
CTRL+G  »»» Displays the  Go To  dialog box.
F5 also displays this dialog box.
CTRL+H  »»» Displays the             Find and Replace  dialog box,  with the  Replace tab selected.
CTRL+I  »»» Applies or removes italic formatting.
CTRL+K  »»» Displays the             Insert Hyperlink  dialog box for new hyperlinks or the  Edit Hyperlink  dialo g b ox for selected existing hyperlinks.
CTRL+N  »»» Creates a new,  blank workbook.
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+SHIFT+P opens the Format Cells dialog box with theFont tab selected.
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+T  »»» Displays the Create Table  dialog box.
CTRL+U  »»» Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
CTRL+V  »»» 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.
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  »»» 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 that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.