Set the shadow spacing effect for Excel data tables

In tables that contain a lot of data, we often use shadow spacing to improve the display, but it's a hassle to set the background color one line at a row. Here are two good ways to tell you.

Method One: If your data area is A2 to C100, change the background of the A3 to C3 to light gray, then select A2 to the C3 area, perform the Copy command on the Edit menu, select A4 to the C100 area, perform the Paste on Edit menu, select Format, press OK button to exit. This gets the data table with the interval shadow. or after the A3 to C3 background modified, select the A2 to C3 area, press the format of the icon Bar button, and then drag and drop with the mouse to select the Settings area A4 to the C100 area, can also achieve the same effect.

Method Two: Select the area you want to set, and in the Format menu, select Conditional Formatting .... In the Conditional Formatting dialog box, select the Drop-down list in the left column as formula and enter "=mod (ROW (), 2) =0" (excluding quotes) in the right column. Click the Format button, and then select the Pattern tab in the Cell Format dialog box that pops up. Select the appropriate background color in the palette, we typically choose light gray, press OK to exit the Cell Format dialog box, and then press OK to exit the Conditional Formatting dialog box. You will get a data table of gray and White (which may also be white, depending on the parity of the ordinal number of the first row in the set area). If you invert the color of the interval, simply change the input section in the right column to "=mod (ROW (), 2) =1".

Conclusion: The method is suitable for the data input completed table processing, if inserted in the new row, the shadow effect is destroyed, need to reset. Method Two more intelligent, it processed data range whether the increase or deletion of rows, will not affect the effect, it will dynamically change the