Page 152 - Excel 2007 Bible

11_044039 ch07.qxp 11/21/06 11:51 AM Page 109
Worksheet Formatting
ormatting your worksheet is like the icing on a cake — it may not be
absolutely necessary, but it can make the end product a lot more attractive. IN THIS CHAPTER
FIn an Excel worksheet, formatting can also make it easier for others to Understanding how formatting
understand the worksheet’s purpose.
can improve your worksheets
Stylistic formatting isn’t essential for every workbook that you develop —
especially if it is for your own use only. On the other hand, it takes only a few Getting to know the formatting
moments to apply some simple formatting, and, once applied, the formatting will tools
remain in place without further effort on your part.
Using formatting in your
In Chapter 6, I show how easy it is to apply formatting to a table. The informa- worksheets
tion in this chapter applies to normal ranges. I show you how to work with the
Excel formatting tools: fonts, colors, and styles, such as bold and italic. I also Using named styles for easier
cover custom styles that you can create to make formatting large amounts of formatting
material in a similar way easier.
Understanding document
themes
Getting to Know the Formatting Tools

Figure 7.1 shows how even simple formatting can significantly improve a work-
sheet’s readability.
This workbook is available on the companion CD-ROM. The
ON the CD-ROM file is named loan payments.xlsx.
ON the CD-ROM

109