Author: Oscar Cronquist Article last updated on February 23, 2018

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


  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!