CTRL combination shortcut keys

Microsoft Excel 2007

CTRL+SHFT+(

Unhides any hidden rows within the selection.

+ ����� –

CTRL+SHFT+)

Unhides any hidden columns within the selection.

+ ����� –

CTRL+SHFT+&

Applies the outline border to the selected cells.

+ ����� –

CTRL+SHFT_

Removes the outline border from the selected cells.

+ ����� –

CTRL SHFT ~

Applies the General number format in Microsoft Excel.

+ ����� –

CTRL+SHFT+$

Applies the Currency format with two decimal places (negative numbers in parentheses).

+ ����� –

CTRL+SHFT+%

Applies the Percentage format with no decimal places.

+ ����� –

CTRL+SHFT+^

Applies the Exponential number format with two decimal places.

+ ����� –

CTRL+SHFT+#

Applies the Date format with the day, month, and year.

+ ����� –

CTRL+SHFT+@

Applies the Time format with the hour and minute, and AM or PM.

+ ����� –

CTRL+SHFT+!

Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

+ ����� –

CTRL+SHFT+*

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+SHFT+:

Enters the current time.

+ ����� –

CTRL+SHFT+

Copies the value from the cell above the active cell into the cell or the Formula Bar.

+ ����� –

CTRL SHFT Plus ( )

Displays the Insert dialog box to insert blank cells in Microsoft Excel.

+ ����� –

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 in Microsoft Excel.

+ ����� –

CTRL+5