Alternate Row Coloring in Excel 2010

You can easily color / highlight the alternate rows in Excel 2010 worksheet with the Format Painter.

To apply coloring for alternate rows, first select the 1st and 2nd and select appropriate colors to it.

With the 2 rows selected now click the format painter icon from the Home Tab.

Drag the format painter to the rest of the rows below the selected two rows. This will apply the formatting with colors to the alternate rows.

Leave a Reply