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.

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.

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

You can freeze a row in Excel so it's easier to compare data as you scroll through the spreadsheet. You can choose to only freeze the first visible row in your Excel sheet, or freeze multiple rows.

How to Highlight Every Other ID in Excel. When reading across a wide list of data, such as an account ledger or product description list, it is easy to confuse the rows.

How to Link Rows Together in Excel. In addition to storing typed data in each cell of a spreadsheet, Microsoft Excel allows you to perform functions on one cell and show the result in another cell ...

If there are many blank rows in your Excel sheet, you can delete them and tidy up the document using the "Find and Select" feature. Here's how.

How do you set up a worksheet with alternating colored rows like the traditional columnar pad design? There are many ways, but the easiest, for both Excel 2003 and 2007 is with a Conditional ...

The typical unhiding techniques don't work everywhere in Excel. Learn an easy to remember method for unhiding row 1 and column A.