Special Edition Using Microsoft® Office Excel® 2007

Chapter 32. Formatting Worksheets

In this chapter

Why Format Worksheets? 892

Using Traditional Formatting 893

Formatting with Styles 914

Other Formatting Techniques 915

Copying Formats 921

Formatting adds interest and readability to documents. If you have taken time to create a spreadsheet, you should also take the time to make sure that it is eye catching and readable.

You can format documents in Excel 2007 with any of these three methods:

• Use tables styles—As described in Chapter 8, “Fabulous Table Intelligence,” you can use table styles to quickly format a table with banded rows, accents for totals, and so on.
• Use cell styles—You can use cell styles to identify titles, headings, and accent cells. The advantage of using cell styles is that ...