REPEAT ROWS AND COLUMNS IN PRINTOUTS

Here's a tip to pass on to your users who often have big print jobs: When you need to print hundreds or thousands of rows of data, you don't want to simply print the range. If you do, only the first page of the printout will contain column labels. To repeat the row or rows that contain column labels on every page of your printout, go to File | Page Setup. In the Print Titles section of the Sheet tab, click the button to the right of the Rows To Repeat At Top field.

When you do, Excel will wait for you to select the row or rows you want to repeat on every page. To return to the Sheet tab, click the button again and then click OK. You don't have to worry about changing the print area for the page that already contains the rows you selected; Excel knows not to repeat them twice on the same page.

Sometimes, due to inevitable spreadsheet bloat, you wind up with more columns than will fit from left to right on legal-size paper in Landscape mode, and Excel prints them on separate pages. If the important columns are on the leftmost side of the print range, your readers may have difficulty matching up the rows on those extra pages.

A quick workaround to orphaned columns is to tell Excel to repeat the key column or columns on the left side of every single page. Go to File | Page Setup again. In the Print Titles section of the Sheet tab, this time click the button to the right of the Columns To Repeat At Left field. Select the column or columns you want to repeat on the left, click the button to return to the Sheet tab, and click OK.

Created Date: 03/13/2002  Last Reviewed: 03/13/2002  Rev. Date: