6. Formatting Cells

Formatting Basics

To paraphrase an old Excel mentor of mine, formatting a worksheet is like putting on its makeup. The worksheet’s contents may be perfectly correct, but by applying formatting, you can make a better impression on the people who see it (Figures 1 and 2).

Figure 1. While content should be more important than appearance, you can bet that this worksheet won’t get as much attention ...


Figure 2. ... as this one.


Excel offers a wide range of formatting options you can use to beautify your worksheets:

Number formatting ...

Get Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.