Control Commands Using The Keyboard

Key	Description
CTRL+B	Add or remove Bold Formatting.
CTRL+W	Closes the selected workbook.
CTRL+SHIFT+)	Column Unhide within selected columns.
CTRL+'	Copies a formula from the cell above the active cell into the cell.
CTRL+C	Copies selected cells. CTRL+C followed by another CTRL+C shows the Clipboard.
CTRL+ALT+V	Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents or contents in another program.
CTRL+SHIFT+$	Currency format with two decimal places. Negative numbers are shown with parentheses.
CTRL+;	Current date.
CTRL+SHIFT+:	Current time.
CTRL+SHIFT+#	Date format with day, month and year.
CTRL+8	Displays / hides the outline symbols.
CTRL+T	Displays the Create Table dialog box.
CTRL+Minus (-)	Displays the Delete dialog box.
CTRL+H	Displays the Find and Replace dialog box (replace tab selected).
CTRL+1	Displays the Format Cells dialog box.
CTRL+SHIFT+Plus (+)	Displays the Insert dialog box.
CTRL+D	Fill Down command copies the contents and format of the topmost cell of a selected range into the cells below.
CTRL+R	Fill Right command copies the contents and format of the left most cell of a selected range into the cells to the right.
CTRL+SHIFT+ ~	General number format.
CTRL+0 or CTRL +9	Hides selected columns / Hides selected Rows.
CTRL+K	Displays the hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+A	If the worksheet has data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and any summary rows.
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+I	Italic formatting applied or removed from text.
CTRL+SHIFT+!	Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHIFT_	Outline border is remove from selected cells.
CTRL+SHIFT+&	Outline border is applied to the selected cells.
CTRL+SHIFT+%	Percentage format with no decimal places.
CTRL+Y	Repeats the last command or action.
CTRL+SHIFT+(	Row Unhide within selected rows.
CTRL+SHIFT+*	Selects the current region around active cells (all the data encompassed by blank rows and blank columns).
CTRL+SHIFT+@	Time format with the hour and minute, with AM or PM.
CTRL+U	Underlining applying or removing.
CTRL+Z	Undo command to reverse the last command or to delete the last entry typed.