CTRL COMBINATION SHORTCUT KEY’S

shortcut key’s            description

CTRL+PgUp                 Switches between worksheet tabs, from left-to-right.

CTRL+PgDn                 Switches between worksheet tabs, from right-to-left.

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.  

Note about CTRL+A: 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 display the 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 Find and Replace dialog box, with the Find tab selected.

SHIFT+F5                  also display this tab, while SHIFT+F4 repeats the last Find action.

CTRL+SHIFT+F        open the Format Cells dialog box with the Font 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 dialog box 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         select all cells that contain comments.

CTRL+P                     Displays the Print dialog box.

CTRL+SHIFT+P        Opens the Format Cells dialog box with the Font 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        display 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         use the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.