Implementation of cross coloring of Excel table rows and columns

For Excel table rows and columns of various coloring methods, the online introduction is very detailed, the author also benefited from. The above methods are related to functions, and are very convenient to use. , the Excel function is very rich, and powerful, is a major feature of it. But in the practical application, the average user's mastery of the function is limited to a few commonly used functions, and it is quite unfamiliar to others. Can the above operation be achieved without function?

After practice, I found that the use of the function can also achieve the intersection of Excel rows and colors, and the column can be colored. Its operation pattern is various, simple and easy, more convenient than using function.

For example, when you are making an alternate color, select the cell b2:g2 you want to color first. Then locate the Fill Color button on the drawing or Formatting toolbar, click the Triangular pop-up drop-down menu to the right of it, and then fill it with the color selected.

After you b2:g2 the cells, select b2:g3 cells, point to the fill handle in the lower-right corner of the selection, and then drag the mouse down to get the effect of shading.

For two or more rows of interleaved coloring, the reference to the above method can also be implemented. First, the first few lines of coloring, to form a circular rule, and then select these lines and then fill down.

For a column to be shaded, it is also convenient to reference the line's coloring method.

Oh, simple? Try it, you can do it.