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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…