How to alternate row colors in Excel To apply color in alternate rows or columns in Excel, follow these steps- Open the spreadsheet with Excel. Select the rows and columns that you want to colorize.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...