Ways to fill the rows in an Excel table

ways to fill the rows in an Excel table

To do this, click any cell in the data area and insert the table

The above steps to insert a table can also be completed by pressing the shortcut key "Ctrl+t", which is more convenient and quick.

And you can change the color of the table by setting the table style.

In addition, there is a way to use conditional formatting to complete.

Select the data range, click Start Conditional formatting new rule, use a formula to determine which cell to format, and enter the following formula:

=mod (ROW (), 2)

=mod (ROW (), 2) The meaning of this formula must everyone know?

To put it simply: the row () function returns the row number of the cell in which the formula is located, and then uses the MoD function to calculate the remainder of the current cell's row number and 2, with a result of 0 or 1.

In conditional formatting, the specified highlight format is executed if the formula used returns a logical value of TRUE or is a value other than 0. So all the line numbers are singular, which is filled with the specified color.

Using formulas to format conditional formatting looks more like a process, but it's more flexible to use. We can also set the number of rows at any interval, such as setting an interval of 5 rows fill color, you can use the following formula in conditional formatting:

=mod ((ROW (A1)-1)/5,2) <1

Think about how the formula should be modified if three rows are highlighted or 8 rows are highlighted?

The summary is:

A lot of data,

Easy to see wrong.

Insert a table,

The alternate color is filled.