Current location - Training Enrollment Network - Early education courses - How to quickly fill a table with colors every other line in excel?
How to quickly fill a table with colors every other line in excel?
We set the interlaced background color of this table to yellow, that is, all even numbers in the serial number become yellow background color.

First, manually change the background color of the second line to yellow, as shown below:

Second, manually select line number 1.2, copy, right-click copy or shortcut key CTRL+C. The following figure:

Third, manually select lines 3-22 of other shortcut keys in the serial number, right-click to select the format in paste, and select the symbols circled in red, as shown in the following figure:

Close up:

Finally, finish. Of course, the formula is also ok, which is a bit troublesome. The results are as follows.

There are many methods and formulas, but I personally think this method is simple and easy to master. Friends who feel practical remember to like it!