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.

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

Excel Print Titles is an important feature for multipage reports where the columns and rows of related data spill over to other pages. Learn to use this feature effectively.

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.