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.

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

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.

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

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

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.

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.