Page 249 - Excel Data Analysis

13 537547 AppA.qxd 3/4/03 11:58 AM Page 235

EXCEL KEYBOARD SHORTCUTS A

FORMATTING SHORTCUTS

SHORTCUT RESULT
Alt + O Selects the Format menu on the Menu bar.
Alt + ' Opens the Style dialog box.
Ctrl + 1 Opens the Format Cells dialog box.
Ctrl + B Applies or removes bold formatting.
Ctrl + I Applies or removes italic formatting.
Ctrl + U Applies or removes underlining.
Ctrl + S Applies or removes strikethrough formatting.
Ctrl + Shift + ~ Applies the General number format.
Ctrl + Shift + $ Applies the Currency format with 2 decimal places and negative numbers in
parentheses.
Ctrl + Shift + ^ Applies the Exponential formatting with 2 decimal places.
Ctrl + Shift + # Applies the Date format with dates formatted as dd-mm-yy.
Ctrl + Shift + @ Applies the Time format with hour, minute, and AM or PM.
Ctrl + Shift + ! Applies the Number format with 2 decimal places, a thousands separator, and
minus sign for negative numbers.
Ctrl + Shift + & Applies the outline borders.
Ctrl + Shift + _ Removes the outline borders.
Alt + Shift + Right Arrow Displays the Group dialog box.
Alt + Shift + Left Arrow Displays the Ungroup dialog box.
Ctrl + 9 Hides the selected rows.
Ctrl + Shift + ( Unhides the hidden rows within the range selection.
Ctrl + 0 Hides the selected columns.
Ctrl + Shift + ) Unhides the hidden columns within the range selection.

235