First page number

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top