Microsoft Office Tutorials and References
In Depth Information
Fonts and Color
Fonts and Color
As in almost any Windows program, you can customize the text in Excel, applying
a dazzling assortment of colors and fancy typefaces. You can do everything from
enlarging headings to colorizing big numbers. Here are the individual font details
you can change:
• The font style . (For example, Arial, Times New Roman, or something a little
more shocking, like Futura Extra Bold.) Calibri is the standard font for new
worksheets. If you have an old-school workbook created by Excel 2003, you’ll
notice that it uses 10-point Arial instead.
• The font size, in points . The standard point size is 11, but you can choose
anything from a minuscule 1-point to a monstrous 409-point. Excel automatically
enlarges the row height to accommodate the font.
• Various font attributes, like italics, underlining, and bold . Some fonts have
complimentary italic and bold typefaces, while others don’t (in which case
Windows uses its own algorithm to make the font bold or italicize it).
• The font color . This option controls the color of the text. (Page 459 covers how
to change the color of the entire cell.)
To change font settings, first highlight the cells you want to format, choose
Home ➝ Cells ➝ Format ➝ Format Cells, and then click the Font tab (Figure 16-11).
Here’s an example of how to apply
an exotic font through the Format
Cells dialog box. Keep in mind that
when displaying data, and especially
numbers, sans-serif fonts are usually
clearer and look more professional
than serif fonts. (Serif fonts have little
embellishments, like tiny curls, on the
ends of the letters; sans-serif fonts
don’t.) Arial, the default spreadsheet
font, is a sans-serif font. Adobe
Minion, the font used for the body text of
this topic, is clearly a serif font, which
works best for large amounts of text.