excel 2002 pagenumbering when workbook is along y-axis instaed

[aamir]

I hope I did not confuse you with x and y. x is starting from left sheet 1,
sheet 2, etc. Y means i use sheet 1, and then copy and paste below, it
successivley 2, 3, etc. Then I select the whole vertical area as the print
area. I do page break and get say 7 pages

How do i number these automatically as 1 of 7, 2 of 7, 3 of 7---

How do i number these as 2 of 8, 3 of 8, etc. if I have the cover sheet as a
Word document, which i have numbered as 1 of 8 ?

Thank you very much

 

[Gord Dibben]

Why not just print the selected sheets without copying all to one sheet?

Right-click on sheet1 then "select all sheets" or CTRL + click to select
non-contiguous sheets.

File>Page Setup>Sheet>First Page Number........Auto...........2 if using the
cover page.

Headers and Footers>Footer Page 2 of ?

Print Preview to see the Footer and then Print.


Gord Dibben MS Excel MVP