Page 336 - Excel Workbook for Dummies

37_798452 ch26.qxp 3/13/06 7:51 PM Page 319

Chapter 26

Ten (More or Less) Shortcut Keys

for Formatting the Worksheet

s you can see in Table 26-1, Excel supports a fair number of formatting shortcut keys.
AAlthough many of these shortcut keys duplicate the functions of buttons on Excel’s
Formatting toolbar, you may find that you prefer the keyboard shortcuts for applying the
most common formatting to the cells in the data tables and lists you work with because
their use enables you to keep your hands on the keyboard and your attention focused on
the spreadsheet itself.

Table 26-1 Formatting Shortcut Keys

Press To
Ctrl+1 Display Format Cells dialog box
Alt+’ (apostrophe) Display Style dialog box
Ctrl+Shift+~ (tilde) Apply General number format
Ctrl+Shift+$ Apply Currency number format with two decimal places and negative
numbers in parentheses
Ctrl+Shift+% Apply Percent number format with no decimal places
Ctrl+Shift+# Apply Date number format with day, month, and year, as in 15-Feb-06

Ctrl+Shift+@ Apply Time number format with hour and minute and AM/PM,
as in 12:05 PM
Ctrl+Shift+! Apply Comma number format with two decimal places
Ctrl+B Add or remove bold

Ctrl+I Add or remove italics
Ctrl+U Add or remove underlining
Ctrl+5 Add or remove strikethrough

Ctrl+Shift+& Apply outline border to current range
Ctrl+Shift+_ (underline) Remove outline border from current range