How to set the shading of EXCEL table

In excel tables, the shading is white by default. If you look at it for a long time, it will have a certain impact on your eyes.

We can change the color of the shading by setting the shading, so that the content of the table is clear at a glance, and it can also protect your eyes!

Take EXECEL 2013 as an example, Table shading settingThe steps are as follows:

The first step, Select the area where you want to add shading, and click the function expansion button in the "Font" group under the "Home" tab, as shown below.

Second step, In the pop-up "Format Cells" dialog box, click to switch to the "Fill" tab, and under the " In the "Background Color (C)" color panel, select the color option you want to fill, as shown below.

The third step, Select the "Orange" option in the "Pattern Color (A)" drop-down list box, and select the "Pattern Style" drop-down list Select any option in the box, click the "OK" button, as shown below, and you can see the effect!

The fourth step, select the cell range to be set, and then repeat the first step. Open the "Format Cells" dialog box, switch to the "Fill" tab, and click the "Fill Effect (I)..." button, as shown below.

The fifth step, In the pop-up "Fill Effect (I)..." dialog box, select "Color 1(1)", Select a different color from the "Color 2 (2)" drop-down list, select "Corner Radiation (F)" under "Shading Style", view the preview effect in the "Sample" area, and click the "OK" button. As shown below.

Step 6, After returning to the "Format Cells" dialog box, continue to click OK, and then return to the worksheet to view the effect. That’s it, as shown below.

Isn’t it very simple, can you do it?

The above is the detailed content of How to set the shading of EXCEL table. For more information, please follow other related articles on the PHP Chinese website!