80
22
33
55
66
11
44
4
To format the text as italic,
click the Italic button (
).
5
To format the text as
underline, click the Underline
button (
).
•
Excel applies the effects to the
selected range.
6
Click the Font dialog box
launcher (
).
1
Select the range you want to
format.
2
Click the Home tab.
3
To format the text as bold,
click the Bold button (

Yes. Excel supports the following font shortcuts:
Press To
+
Toggle the selected range as bold
+
Toggle the selected range as italic
+
Toggle the selected range as underline
+
Toggle the selected range as strikethrough
8
To format the text as a
superscript, click Superscript
(
changes to ).
•
To format the text as a
subscript, click Subscript
(
changes to ).
9
Click OK.

Excel applies the font effects.

The Format Cells dialog box
appears with the Font tab
displayed.
7
To format the text as

When you build an Excel worksheet, you can
add visual interest to the sheet text by
changing the font color.
By default, each Excel workbook comes with a
theme applied, and you can change the font
color by applying one of the colors from the
workbook’s theme. You learn more about
workbook themes in Chapter 9.
You can also select a color from Excel’s palette
of standard colors, or from a custom color that
you create yourself.
Change the
Font Color
07_577639-ch05.indd 8207_577639-ch05.indd 82 3/15/10 2:41 PM3/15/10 2:41 PM
83
Formatting Excel Ranges
CHAPTER
5
11
55
66
22
33
44
How can I make the best use of fonts in my documents?
•
Do not use many different typefaces in a single document. Stick to one, or at
most two, typefaces to avoid the ransom note look.
•
Avoid overly decorative typefaces because they are often difficult to read.

Select the range you want to
format.
2
Click the Home tab.
3
Click in the Font Color
list (
).
4
Click More Colors.
07_577639-ch05.indd 8307_577639-ch05.indd 83 3/15/10 2:42 PM3/15/10 2:42 PM
84
11
22
33
Align Text Horizontally
1
Select the range you want to
format.
2
Click the Home tab.
3
In the Alignment group, click
the horizontal alignment
option you want to use:

Click Align Text Left ( ) to
align data with the left side of
each cell.