Microsoft Excel 2007 tutorial: apply or remove cell shading


Apply or remove cell shading



IV. Apply or remove cell shading

You can apply shading to cells by filling them with solid colors or specific patterns; and you can remove the cell shading if you don't need it any more.

IV.1. Fill cells with solid colors

To add shading to cells, do the following:

- Select the cells that you want to apply shading.

- On the Home tab, in the Font group, click drop-down arrow next to Fill Color, and then select a solid color that you like on the color palette.

 Excel 2007 Fill Color

Notes:

- If you want to fill cells with a recently selected color, click the Fill Color after selecting the cells.

- Click More Colors if the colors on the color palette are not your need.

IV.1. Fill cells with patterns

To fill cells with a pattern, do the following:

-  Select the cells that you want to apply a pattern.

- On the Home tab, in the Font group, click Format Cell Font dialog box launcher.

Excel 2007 Format Cell Font dialog box launcher

- On the Format Cells dialog box, click Fill tab.

- Under the Background Color, click the color that you want to fill.

Excel 2007 select a color under background color

 - Do one of the following:

   ▫ If you want to use a pattern with two colors, click another color in the Pattern Color box, and then click a pattern style in the Pattern Style box. Lastly, click Ok button to apply this format.

   Excel 2007 Patter Color Excel 2007 Pattern Style

   ▫ If you want to use a pattern with a special effect, click Fill Effects button, and then select the option that you want in the Gradient tab. Finally, click Ok button to add this format.

  Excel 2007 Fill Effect dialog box   

IV.1. Remove cell shading

 To take the cell shading off, do the following:

- Select the cells that contain a fill color or fill pattern

- On the Home tab, in the Font group, click drop-down arrow next to Fill Color, and then click No Fill under the Standard Color and above the More Colors .

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.