Shortcut Commands 101

CTRL combination shortcut keys---Shortcut Command

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. + –

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. + –