Article updated on August 04, 2017

If you want each page to have the same row(s) or column(s) to be repeated at every page you print. For instance, same type of data that requires many pages. Print column headers to increase readability.

Instructions: (Excel 2007)

  1. Click with left mouse button the office button on the upper left corner.
  2. Go to print and hover and the click the "print preview" button.
  3. Click with left mouse button on page setup.
  4. Go to tab "Sheet".
  5. Click with left mouse button on the small icon to the most right in the window "Print titles. (See picture below)
  6. Select rows (or columns) to be repeated.
  7. Press OK!