Color Every Other Row In Excel

Tables have many different formatting options. Select the background or pattern color that you want to use for the shaded rows and then click OK. Lets say you want to highlight every second month ie February April and so on in this data set. You can apply the shading by using a simple conditional formatting f.

Shade Alternate Rows In Excel Easy Excel Tutorial

Also note that the.

Color every other row in excel. Select the data or range where you want to add the color in a row. In the Format Cells dialog box click the Fill tab. A trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set.

So your line 6 should now be. Click on the Format button and select the Fill tab from the Format Cells dialog box. It is also possible to shade every 3 rd every 4 th or so row.

In cell D1 the same row of the headers enter the number 0. To apply the shading to a specific range of cells select the cells you want to format. To apply the shading to a specific range of cells select the cells you want.

To select cells in every other column replace the keyword Rows with the keyword Columns. Select whatever color you want your alternate rows to have. This video shows you how to automatically apply shading to every nth row in a worksheet.

How To Shade Every Other Row In Excel 2013 Youtube