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.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

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