First page number

[Betti Punnett]

My first spreadsheet has 61 pages.
My second (with different heading) has 42 pages. I want my second spreadsheet to start at page 62. I follow all instructions ( Auto setting and &[62 but find all pages in the second document are 62.
Why won't it work??

EggHeadCafe - Software Developer Portal of Choice
GDI+ Draw Rounded Corners On Rectangle
http://www.eggheadcafe.com/tutorial...e6-64ce6cd5c819/gdi-draw-rounded-corners.aspx

 

[Mike Rogers]

Try "Grouping" the two worksheets, then applying the page numbers.

Mike Rogers

 

[Gord Dibben]

Couple of methods.

1. Easiest method

Place 61 page worksheet before 42 page worksheet.

Select sheet1 then CTRL + click on second sheet.

View>Header.Footer...........set default header or footer of Page 1

File>Print>Selected Sheets

2. More complex.

Set up 61 page sheet with Page 1 in footer

Select 42 page sheet and File>Page Setup>First Number. Enter 62.

Set Custom footer to Page &Page

Print each worksheet separately.


Gord Dibben MS Excel MVP