4. In the Titles and Headings section, point to Accent1 to see the Live Preview of the style applied to the cells in the selected range. Click Accent1. Blue fill and white font colors are applied to the cells in the selected range. 5. Select the range A9:D9. 6. On the Home tab, in the Styles group, click the Cell Styles button . 7. In the Cell Styles gallery, in the Titles and Headings section, click Accent1. Blue fill and white font are applied to the cells in the selected range. 8. Click cell A1. On the Home tab, in the Styles group, click the Cell Styles button . 9. In the Cell Styles gallery, in the Titles and Headings section, click Heading 1. Click cell E1 to deselect the merged cell A1. The formatting for this style is added to the formatting you already applied to cell A1, as shown in Figure 2–15. FIGURE 2–15 Cell styles applied to cells and ranges 10. Scroll down until you can see row 21, and then click cell A21. On the Home tab, in the Styles group, click the Cell Styles button . 11. In the Cell Styles gallery, in the Titles and Headings section, click Accent3. The cell is formatted with the selected style. 12. On the Home tab, in the Editing group, click the Clear button
4. In the Titles and Headings section, point to Accent1 to see the Live Preview of the style applied to the cells in the selected range. Click Accent1. Blue fill and white font colors are applied to the cells in the selected range. 5. Select the range A9:D9. 6. On the Home tab, in the Styles group, click the Cell Styles button . 7. In the Cell Styles gallery, in the Titles and Headings section, click Accent1. Blue fill and white font are applied to the cells in the selected range. 8. Click cell A1. On the Home tab, in the Styles group, click the Cell Styles button . 9. In the Cell Styles gallery, in the Titles and Headings section, click Heading 1. Click cell E1 to deselect the merged cell A1. The formatting for this style is added to the formatting you already applied to cell A1, as shown in Figure 2–15. FIGURE 2–15 Cell styles applied to cells and ranges 10. Scroll down until you can see row 21, and then click cell A21. On the Home tab, in the Styles group, click the Cell Styles button . 11. In the Cell Styles gallery, in the Titles and Headings section, click Accent3. The cell is formatted with the selected style. 12. On the Home tab, in the Editing group, click the Clear button