Repeat Columns and / or Rows on Every Printed Sheet

SUMMARY: If information in particular rows or columns need to be repeated on every page, here’s how to configure Excel to do so.

 When scanning printouts of larger Microsoft Excel 2010 worksheets, by the time you get to the 10th page or so you may forget the type of data represented by each row or column. To solve this problem, you can configure Excel to repeat certain rows and/or columns on every page that you add to describe the data.

1. Click the “Page Layout” tab in the Ribbon.

2. In the “Page Setup” group, click the “Print Titles” button.

Accessing the “Print Titles” function in Excel 2010

3. The “Paget Setup” dialog appears. Underneath “Print Titles”, enter the row(s) you want repeated next to “Rows to repeat at top”, and the columns you want repeated next to “Columns to repeat at left”. Note that you can click the graphics next to the text boxes to visually choose your row(s) and/or column(s).

Repeating the first three rows of a worksheet on every printed page

4. When done, click “OK” to close the dialog box.