To tell Excel 2007 to repeat one or more rows or columns, first chose the Page Layout tab in the Ruler, then Print Titles (in Excel 2003, choose File | Page Setup, then Sheet).

Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of those are an option, try this simple formula solution.

As this formula is copied to the right, the COLUMN function references cells C1, D1, E1, and so on, which equates to columns 3, 4, 5, and so on, respectively. The result is that each time the formula ...