Microsoft® Excel® 2010 Inside Out

Chapter 9. Worksheet Formatting Techniques

Formatting Fundamentals

Using Themes and Cell Styles

Formatting Conditionally

Formatting in Depth

Using Template Files to Store Formatting

WHEN creating a worksheet in Microsoft Excel 2010, 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 2010, 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, ...