Nội dung

9 Chapter Formatting Excel Workbooks Excel offers several settings that enable you to control the look of a workbook. These include the workbook colors for things like text and borders; fonts that govern the look of headings and regular cell text; and special effects that you can apply to charts and graphic objects. You can also format workbook colors, fonts, and effects all at once by applying a workbook theme. 11_577639-ch09.indd 160 3/15/10 2:45 PM Modify the Workbook Colors . . . . . . . . . . . . . . . . . . . . 162 Set the Workbook Fonts . . . . . . . . . . . . . . . . . . . . . . . 164 Choose Workbook Effects . . . . . . . . . . . . . . . . . . . . . . . 166 Apply a Workbook Theme . . . . . . . . . . . . . . . . . . . . . . 168 11_577639-ch09.indd 161 3/15/10 2:45 PM Modify the Workbook Colors You can give your workbook a new look by selecting a different color scheme. Each color scheme affects the workbook’s text colors, background colors, border colors, and more. Excel offers more than 20 color schemes. To get the most out of Excel’s color schemes, you must apply styles to your ranges, as described in Chapter 5. Modify the Workbook Colors 1 Open or switch to the 2 workbook you want to format. 2 Click the Page Layout tab. 1 3 Click Colors ( ). 3 162 11_577639-ch09.indd 162 3/15/10 2:45 PM 9 CHAPTER Formatting Excel Workbooks 4 Click the color scheme you want to apply. 4 • Can I create my own color scheme? Excel applies the color scheme to the workbook. 4 Yes, by following these steps: 1 Click the Page Layout tab. 2 Click . 3 Click Create New Theme Colors. 4 For each theme color, click and then click the color you want to use. • The Sample area shows what your theme colors look like. 5 6 5 Type a name for the custom color scheme. 6 Click Save. 163 11_577639-ch09.indd 163 3/15/10 2:45 PM Set the Workbook Fonts You can add visual appeal to your workbook by selecting a different font scheme. Each font scheme has two defined fonts: a heading font for the titles and headings, and a body font for the regular worksheet text. Excel offers more than 20 font schemes. To get the most out of Excel’s font schemes, particularly the heading fonts, you must apply styles to your ranges, as described in Chapter 5. Set the Workbook Fonts 2 1 Open or switch to the workbook you want to format. 2 Click the Page Layout tab. 1 3 Click Fonts ( ). 3 164 11_577639-ch09.indd 164 3/15/10 2:45 PM 9 CHAPTER Formatting Excel Workbooks 4 Click the font scheme you want to apply. 4 • • Excel applies the heading font to the workbook’s headings. Excel applies the body font to the workbook’s regular text. 4 Can I create my own font scheme? Yes, by following these steps: 1 Click the Page Layout tab. 2 Click . 3 Click Create New Theme Fonts. 4 Click the Heading font and then click the 6 font you want to use for titles and headings. 5 Click the Body font • 6 5 7 and then click the font you want to use for regular sheet text. The Sample area shows what your theme fonts look like. Type a name for the custom font scheme. 7 Click Save. 165 11_577639-ch09.indd 165 3/15/10 2:45 PM Choose Workbook Effects You can enhance the look of your workbook by selecting a different effect scheme. The effect scheme applies to charts and graphic objects, and each scheme defines a border style, fill style, and added effect such as a drop shadow or glow. Excel offers more than 20 effect schemes. To get the most out of Excel’s effect schemes, you must apply a style to your chart, as described in Chapter 12. Choose Workbook Effects 1 Open or switch to the 2 workbook you want to format. 2 Click the Page Layout tab. 1 3 Click Effects ( ). 3 166 11_577639-ch09.indd 166 3/15/10 2:45 PM 9 CHAPTER Formatting Excel Workbooks 4 Click the effect scheme you want to apply. 4 • Excel applies the effect scheme to the workbook’s charts and graphics. Can I create a custom effect scheme? Why are all the effect schemes the same color? No. Unlike with the color schemes and font schemes described earlier in this chapter, Excel does not have a feature that enables you to create your own effect scheme. The color you see in the effect schemes depends on the color scheme you have applied to your workbook. If you apply a different color scheme, as described in “Modify the Workbook Colors,” you will see a different color in the effect schemes. If you want to use a custom effect color, create a custom color scheme and change the Accent 1 color to the color you want. 167 11_577639-ch09.indd 167 3/15/10 2:46 PM Apply a Workbook Theme You can give your workbook a completely new look by selecting a different workbook theme. Each theme consists of the workbook’s colors, fonts, and effects. Excel offers more than 20 predefined workbook themes. To get the most out of Excel’s workbook themes, you must apply styles to your ranges, as described in Chapter 5; and to your charts, as described in Chapter 12. Apply a Workbook Theme 2 1 Open or switch to the workbook you want to format. 2 Click the Page Layout tab. 1 3 Click Themes ( ). 3 168 11_577639-ch09.indd 168 3/15/10 2:46 PM 9 CHAPTER Formatting Excel Workbooks 4 Click the workbook theme you want to apply. 4 • Excel applies the theme to the workbook. Can I create my own workbook theme? Yes, by following these steps: 1 Format the workbook with a color scheme, font scheme, and effect scheme, as described in the previous three sections. 2 Click the Page Layout tab. 3 Click . 4 Click Save Current Theme. 5 6 The Save Current Theme dialog box appears. 5 Type a name for the custom theme. 6 Click Save. 169 11_577639-ch09.indd 169 3/15/10 2:46 PM