Author: Oscar Cronquist Article last updated on August 10, 2018

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. Click "Header and Footer" button

  3. Click "Go to Footer" button
  4. Click "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. Click Print button