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

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

Repeat rows or columns If your document is extra-wide, or extra-long, you might want to repeat some rows (which may contain data labels) at the top or edge of every page.

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

Click "OK" to filter the Excel data. Repeat the process for all columns that contain cell values of zero until all rows with zero cell values are hidden. Press "Ctrl-P" on your keyboard.

I need to print out each zone on separate pages (so above zone one might take 3 pages while zone 2 might take 1) 3-4 columns on a page, they easily fit width.