Step-By-Step: Repeat rows and columns in printouts

Avoid missing column headers on subsequent pages of your Excel printouts. To print all of your header information, follow the steps in this article.

Here's a tip to pass on to your Excel 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(s) that contain column labels on every page of your printout:
  1. Go to File | Page Setup.
  2. 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(s) 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(s) on the left side of every single page.
  1. Go to File | Page Setup.
  2. In the Print Titles section of the Sheet tab, click the button to the right of the Columns To Repeat At Left field.
  3. Select the column(s) you want to repeat on the left, click the button to return to the Sheet tab, and click OK.

What do you think of this article format?
Our editors are developing and refining new methods and formats for delivering the solutions you need. Do shorter, step-by-step pieces such as this one help you overcome the IT problems that keep you up at night? Share your thoughts with our editors, and you could win a free TechRepublic book or CD of your choice. Content for this article was derived from the TechRepublic Microsoft Office e-newsletter. You can have tips like this delivered via e-mail each week by signing up here.

Editor's Picks

Free Newsletters, In your Inbox