Excel control combination shortcut keys

CTRL Key Combination	Action/Description
CTRL+A	Select all.
CTRL+B	Apply bold/removes bold formatting.
CTRL+C	Copy the selected cells.
CTRL+D	Fill Down contents and format of the topmost cell.
CTRL+F	Displays the Find and Replace dialog box and Find tab selected.
CTRL+G	Displays the Go To dialog box.
CTRL+H	Displays the Find and Replace dialog box and the Replace tab selected.
CTRL+I	Apply/removes italic formatting to the selected text.
CTRL+K	Displays the Insert Hyperlink dialog box.
CTRL+L	Displays the Create Table dialog box for selected cell/cells.
CTRL+N	Creates a new, blank workbook.
CTRL+O	Displays the Open dialog box.
CTRL+P	Displays the Print tab.
CTRL+R	Fill Right the contents and format of the leftmost cell.
CTRL+S	Saves the active file.
CTRL+T	Displays the Create Table dialog box.
CTRL+U	Apply/removes underlining.
CTRL+V	Paste the contents of the Clipboard at the selected cell.
CTRL+W	Closes the selected workbook window.
CTRL+X	Cuts the selected cells.
CTRL+Y	Repeats the last command or action.
CTRL+Z	Undo to reverse the last action.
CTRL+1	Displays the Format Cells dialog box.
CTRL+2	Apply bold/removes bold formatting.
CTRL+3	Apply/removes italic formatting to the selected text.
CTRL+4	Apply/removes underlining.
CTRL+5	Apply/removes strikethrough.
CTRL+6	Alternates between hiding and displaying objects.
CTRL+8	Displays or hides the outline symbols.
CTRL+9	Hides the selected rows.
CTRL+0	Hides the selected columns.
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+&	Applies the outline border to the selected cells.
CTRL+SHIFT_	Removes the outline border from the selected cells.
CTRL+SHIFT+~	Apply the General number format.
CTRL+SHIFT+$	Apply the Currency format with two decimal places.
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.
CTRL+SHIFT+@	Apply the Time format.
CTRL+SHIFT+!	Apply the Number format with two decimal places.
CTRL+SHIFT+*	Selects the current region around the active cell.
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.
CTRL+Minus (-)	Displays the Delete dialog box.
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+F1	Displays/hides the Microsoft Office Excel Ribbon.
CTRL+F2	Displays the Print Preview window.
CTRL+F4	Close the selected workbook window.
CTRL+F5	Restore the window size of the selected workbook window.
CTRL+F6	switches to the next workbook window if multiple workbook window is open
CTRL+F7	Performs the Move command on the workbook window when it is minimized.
CTRL+F8	Performs the Size command on the workbook window when it is minimized.
CTRL+ALT+F9	Calculates all worksheets in all open workbooks
CTRL+F9	Minimize a workbook window to an icon
CTRL+F10	Maximize/restore the selected workbook window.