Microsoft Excel CTRL-SHIFT Combination Shortcut Keys

Microsoft Excel CTRL-SHIFT Combination Shortcut Keys:
Shortcut Keys to Work Smarter in Excel

The following table contains both CTRL and SHIFT combination shortcut keys along with descriptions of their functionality which one can use in Microsoft Excel to work more proficiently. Mastering these key will enable Excel user to skilfully enhance the speed and accuracy or work. The CTRL and SHIFT key can combine any other key on the keyboard, both the alphabet and number keys to perform special functions embedded in them. Constant usage and practice will enhance expertise in the use of these shortcut keys.

CTRL and SHIFT Combination Shortcut Keys

KEY	DESCRIPTION
CTRL+SHIFT+(	CTRL+SHIFT+( unhide any hidden rows within the selection.
CTRL+SHIFT+)	CTRL+SHIFT+) unhide any hidden columns within the selection.
CTRL+SHIFT+&	CTRL+SHIFT+& apply the outline border to the selected cells.
CTRL+SHIFT+_	CTRL+SHIFT+ remove the outline border from the selected cells.
CTRL+SHIFT+~	CTRL+SHIFT+~ apply the General number format.
CTRL+SHIFT+$	CTRL+SHIFT+$ apply the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%	CTRL+SHIFT+% apply the Percentage format with no decimal places.
CTRL+SHIFT+^	CTRL+SHIFT+^ apply the Exponential number format with two decimal places.
CTRL+SHIFT+#	CTRL+SHIFT+# apply the Date format with the day, month, and year.
CTRL+SHIFT+@	CTRL+SHIFT+@ apply the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!	CTRL+SHIFT+! apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT+*	CTRL+SHIFT+* select 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+:	CTRL+SHIFT+: enter the current time.
CTRL+SHIFT+"	CTRL+SHIFT+" copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+Plus (+)	CTRL+Plus (+) display the Insert dialog box to insert blank cells.
CTRL+Minus (-)	CTRL+Minus (-) display the Delete dialog box to delete the selected cells.
CTRL+;	CTRL+; enter the current date.
CTRL+`	CTRL+` alternate between displaying cell values and displaying formulas in the worksheet.
CTRL+'	CTRL+' copy a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1	CTRL+1 display the Format Cells dialog box.
CTRL+2	CTRL+2 apply or removes bold formatting.
CTRL+3	CTRL+3 apply or removes italic formatting.
CTRL+4	CTRL+4 apply or remove underlining.
CTRL+5	CTRL+5 apply or remove strikethrough.
CTRL+6	CTRL+6 alternate between hiding objects, displaying objects, and displaying placeholders for objects.

CTRL+8	CTRL+8 display or hides the outline symbols.
CTRL+9	CTRL+9 hide the selected rows.
CTRL+0	CTRL+0 hide the selected columns.
CTRL+A	CTRL+A select the entire worksheet. If the worksheet contains data, CTRL+A select the current region. Pressing CTRL+A the second time select the current region and its summary rows. Pressing CTRL+A the third time select the entire worksheet. When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box. CTRL+SHIFT+A insert the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B	CTRL+B applie or remove bold formatting.
CTRL+C	CTRL+C Copy 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	CTRL+F displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also display this tab, while SHIFT+F4 repeat the last Find action. CTRL+SHIFT+F open the Format Cells dialog box with the Font tab selected.
CTRL+G	CTRL+G display the Go To dialog box. F5 also displays the same Go To dialog box.
CTRL+H	CTRL+H display the Find and Replace dialog box, with the Replace tab selected.
CTRL+I	CTRL+I apply or remove italic formatting.
CTRL+K	CTRL+K display the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N	CTRL+N Create a new, blank workbook.
CTRL+O	CTRL+O display the Open dialog box to open or find a file. CTRL+SHIFT+O select all cells that contain comments.
CTRL+P	CTRL+P displays the Print dialog box. CTRL+SHIFT+P open the Format Cells dialog box with the Font tab selected.
CTRL+R	CTRL+R use 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	CTRL+S save the active file with its current file name, location, and file format.
CTRL+T	CTRL+T displays the Create Table dialog box.
CTRL+U	CTRL+U apply or remove underlining. CTRL+SHIFT+U switch between expanding and collapsing of the formula bar.
CTRL+V	CTRL+V Insert the contents of the Clipboard at the insertion point and replace any selection. Available only after you have cut or copied an object, text or cell contents.
CTRL+W	CTRL+W Close the selected workbook window.
CTRL+X	CTRL+X Cut the selected cells.
CTRL+Y	CTRL+Y repeat the last command or action, if possible.
CTRL+Z	CTRL+Z use 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.