CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition.
DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference
| Shortcut | Action |
| Ctrl+Shift | Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right |
| Ctrl+Shift+A | Insert argument names and parentheses when the insertion point is to the right of a function name in a formula |
| Ctrl+Shift+F (or P) | Format fonts in the Format Cells dialog |
| Ctrl+Shift+G | Open the Workbook Statistics dialog |
| Ctrl+Shift+L | Apply / Remove Auto-filter |
| Ctrl+Shift+O | Select all cells containing Notes (earlier called comments) |
| Ctrl+Shift+U | Expand/Collapse Formula bar |
| Ctrl+Shift++ | Open the Insert dialog to insert blank cells |
| Ctrl+Shift+: | Enter the current time |
| Ctrl+Shift+& | Apply an outline border to the selected cells |
| Ctrl+Shift+_ | Remove the outline border from the selected cells |
| Ctrl+Shift+~ | Apply the General number format |
| Ctrl+Shift+$ | Apply the Currency format with two decimal places (negative numbers in parentheses) |
| Ctrl+Shift+% | Apply the Percentage format with no decimal places |
| Ctrl+Shift+^ | Apply the Scientific number format with two decimal places |
| Ctrl+Shift+# | Apply the Date format with the day, month, and year |
| Ctrl+Shift+@ | Apply the Time format with the hour and minute, and AM or PM |
| Ctrl+Shift+! | Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values |
| Ctrl+Shift+* | Select the current region around the active cell |
| Ctrl+Shift+( | Unhide Rows |
| Ctrl+Shift+= | Insert Rows / Columns when row/column is selected or display insert menu when cell is selected |
| Ctrl+Shift+Spacebar | Select the entire worksheet (equivalent to CTRL+A)
Select all objects on a worksheet when an object is selected |
| Ctrl+Shift+Page Down | Select the current and next sheet in a workbook |
| Ctrl+Shift+Page Up | Select the current and previous sheet in a workbook |
| Ctrl+Shift+Home | Extend the selection of cells to the beginning of the worksheet |
| Ctrl+Shift+End | Extend the selection of cells to the last used cell on the worksheet |
| Ctrl+Shift+Arrow | Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell |
| Ctrl+Shift+Tab | Switches to the previous tab in a dialog, or (if no dialog is open) switches between all Excel windows |
| Ctrl+Shift+Enter | Confirm a formula as Array formula |
| Ctrl+Shift+" | Copy the value from the cell above the active cell into the cell or the formula bar |
| Ctrl+Shift+F2 | Insert a threaded comment / Open and reply to a threaded comment |
| Ctrl+Shift+F3 | Open create name from selection dialog box |
| Ctrl+Shift+F6 | Switches between all Excel windows |
| Ctrl+Shift+F10 | Open the context menu |
| Ctrl+Shift+F12 | Opens print worksheet dialog box |