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.

How to Ungroup Rows and Columns in Excel To ungroup rows and columns in Excel. Highlight the row or column you have grouped. On the Data tab, click Outline on the right corner of the Excel interface.

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.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.