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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

New Corel ParticleShop plugin now available: 11 new brushes & 6 new brush packs

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…