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).

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

Q: I read your colleague David Einstein's description of how to make row and column headings repeat on each page of an Excel spreadsheet in Windows. The Mac version appears to be just a bit ...

I have an excel sheet where there are the data and the titles over these data.I need to find a way to repeat these titles in every single printed page.Untill now, I have to manually copy paste ...

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).