Author: Oscar Cronquist Article last updated on March 14, 2022

This article describes how to print page numbers in consecutive order through specified worksheets and how to repeat column headers on each printed page.

 

1. Print consecutive page numbers across multiple worksheets

This article explains how to print multiple worksheets so the page numbers are in sequence across all selected worksheets.

Instructions:

  1. Go to tab "Insert" on the ribbon
  2. Press with left mouse button on "Header and Footer" button

  3. Press with left mouse button on "Go to Footer" button
  4. Press with left mouse button on "Page number" button
  5. Repeat step 1 to 4 for each sheet
  6. Select the first sheet
  7. Hold "Ctrl" key and select the second sheet
  8. Go to "print preview"
  9. Check that page numbers are ok in preview window
  10. Press with left mouse button on Print button

Back to top

2. Repeat headers on each page

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.

Instructions:

  1. Press with left mouse button on with left mouse button the office button on the upper left corner.
  2. Go to print and hover and the press with left mouse button on the "print preview" button.
  3. Press with left mouse button on with left mouse button on page setup.
  4. Go to tab "Sheet".
  5. Press with left mouse button on 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!

Back to top