Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Worksheet formatting techniques
CHAPTER 9
Worksheet formatting techniques
Formatting fundamentals .........................286
Using themes and cell styles.......................296
Formatting conditionally .........................306
Formatting in depth..............................317
Using template files to store formatting ............365
WHEN creating a worksheet in Microsoft Excel, you probably don’t ask yourself
the question, why use formats? But we’ll answer it anyway. Compare Figure
9-1 to Figure 9-2, and we need say no more. Although the data is the same in
both worksheets, the worksheet in Figure 9-2 takes advantage of the formatting features
available in Excel, and as you can see, it’s much easier to read and interpret. In this
chapter, you’ll learn how to apply basic formatting to help turn your data into information.
We also discuss advanced formatting features such as themes, cell styles, and conditional
formatting.
Figure 9-1 All entries in this worksheet are displayed in their default formats.
285
Search JabSto ::




Custom Search