Microsoft Excel 2013 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, 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 ...