Adding Cell Backgrounds and Shading

Sometimes creating or applying a workbook theme is too much work. If all you want to do is highlight the value in a cell by changing the cell’s background to red, you shouldn’t go to the trouble of finding the theme that includes red as one of its colors. Instead, you can simply change the background color of cells to make those cells stand out. Be sure there’s enough contrast between the background and text colors, however. Very little is worse than having to squint at the monitor to read text that blends in with the background color.

Add Background Color

  1. Select the cells you want to change.

  2. Click the Home tab.

  3. In the Font group, click the Fill Color down arrow.

  4. Select the background color you want.

    Add Background Color

Change Background Shading

  1. Select the cells you want to change.

  2. Right-click the selection and click Format Cells from the shortcut menu.

  3. Click the Fill tab.

  4. Click the Pattern Color down arrow and then select the color you want.

  5. Click the Pattern Style down arrow and then select the pattern you want.

  6. Click OK.

    Change Background Shading

    Caution

    Caution

    If you select a set of cells, Excel applies the border you select to the entire selection. Selecting cells A2 and B2 and choosing Thick Bottom Border, therefore, would place a thick border on the bottom edge of cell B2, not on the bottom edges of cells A2 and B2.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.133.134.151