Excel Continous pagenumbering

H

hhalle

Can anybody help me with the following issue:
I have an Excel workbook with several filled sheets, when printint eac
sheet may contain more than one page.
When adding pagenumers and selecting a group of sheets, the pagenumbe
always starts with 1 for each sheet.
I would like to number continously:
E.g.:
Sheet 1 contains 2 pages
Sheet 2 contains 1 page
Sheet 3 contains 4 pages

When grouping and adding current page Nr /total number op pages in th
footer the total shows page x / 7
thus: 1/7, 2/7, 1/7, 1/7,2/7, 3/7, 4/7 instead of 1/7 through 7/7

Any ideas?

Thank You,

Hans :
 
D

Dave Peterson

What happens if you group Sheet1, sheet2, and sheet3. Then print those selected
sheets?

(Click on sheet1's worksheet tab, then ctrl-click on the subsequent to group
them.)

Be careful when the worksheets are grouped. Almost anything you do to one sheet
will be done to the others in the group.
 
E

Earl Kiosterud

Hhalle,

It sounds as if the first page number in File - Page setup is set to 1. Set
it to Auto.
 
D

Dave Peterson

Thanks for the better answer, Earl.

(I missed the part that said that hhalle had already grouped the sheets.)
 
H

hhalle

Hi Earl,

It works, thanks, I thought I had the numbering on auto but . . .
checked it and it works, thanks.

Han
 
Top