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.

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.

Q: I need to be able to easily color every other row in Excel 2003 and Excel 2007. Can you help me with this?

Click the View button in the top taskbar. Select Freeze. Click 1 row to freeze the top row, 2 rows to freeze the top two rows, or Up to row (X) to freeze every row up to your currently-selected cell.