Printing Excel Workbook with Page Numbers

  Zak 22:10 11 Jul 2003
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 2003

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 2003

Additional methods at click here

  Megatyte 22:17 11 Jul 2003

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

AH

  Zak 22:48 11 Jul 2003

Jazzypop

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

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse's new logo: the trainer brand looks to its heritage for a fresh identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?