Printing Excel Workbook with Page Numbers

  Zak 22:10 11 Jul 03
Locked

I need to print 10 Worksheets from an Excel Workbook and have them all consecutively page numbered.

I am able to page number each Worksheet, but the numbers start from 1 for each Worksheet.

Is there a better way than just creating one Worksheet from the 10 separate ones?

  jazzypop 22:14 11 Jul 03

have you tried to use File/Print... and checked the whole Workbook option?

Excel will print all sheets and its containing pages with a consecutive number.

Source - click here

  jazzypop 22:16 11 Jul 03

Additional methods at click here

  Megatyte 22:17 11 Jul 03

Click View - Header and Footer and then select any of the options.

AH

  Zak 22:48 11 Jul 03

Jazzypop

Thanks for your links. The ReportManager works a treat and problem solved.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5