1. Computing

Excel 2007 Spreadsheet Print Options Part 2

By

4 of 6

Print Titles on Multiple Pages
Print Titles on Multiple Pages in Excel

Print Titles on Multiple Pages in Excel

© Ted French

Print Titles on Multiple Pages

For large worksheets that exceed one page in length or width, Excel allows you to reprint specific rows or columns on each page in order to make it easier to read and understand your data.

Normally these rows or columns contain titles or headings and are located at the top or left hand side of the worksheet.

Steps to Reprint Rows at the Top of Every Page

Note: For help with these instructions see the image above.

  1. Open a worksheet containing data that exceeds one page in length.

  2. Click on the Page Layout tab of the ribbon.

  3. Click on the Print Titles icon located near the center of the ribbon to open the Page Setup dialog box.

  4. Click on the Sheet tab at the top of the dialog box if necessary to select it.

  5. Click in the Rows to repeat at top line in the dialog box.

  6. In the worksheet, drag select the rows you want to have printed at the top of each page - the will be surrounded by a dotted line.

  7. Click OK.

  8. Open Print Preview to view the results. The selected rows should be repeated at the top of each page being previewed.

Steps to Reprint Columns on the Left of Every Page

  1. Repeat steps 1 - 4 above.

  2. Click in the Columns to repeat at left line in the Page Setup dialog box.

  3. In the worksheet, drag select the columns you want to have printed on the left of each page - the will be surrounded by a dotted line.

  4. Click OK.

  5. Open Print Preview to view the results. The selected columns should be repeated on the left of each page being previewed.

Note: Titles do not start reprinting until after they appear in the worksheet. For example, if you have selected titles on page 2 of the worksheet to reprint, they will be reprinted on pages 3, 4, and 5, of the printout but they will not be printed on page 1.

©2014 About.com. All rights reserved.