Excel Page x of x based on sheets.

[Joe1010]

I have a document with about 40 sheets. Is there a way to have the Page x of x be displayed on all sheet based on sheet and page? Each sheet has 2 pages.
Like
Sheet 1, Page 1 to display Page 1 of 80
Sheet 1, Page 2 to display Page 2 of 80
Sheet 2, Page 1 to display Page 3 of 80
Sheet 2, Page 2 to display Page 4 of 80
Etc.

Thank you

 

[SkipVought]

Hi,

Select ALL th sheets you want to print.

Check out Print Preview

Skip,

_[red][/red]

 

[Joe1010]

The problem I have is that I’m also printing all cover sheets I have between the sheets. And I do not want to have the page number on the cover sheets; however, I want them to be printed on the order of the sheets.
Thanks

 

[SkipVought]

Hi,

You have to realize that Excel is not a document tool. It's a SPREADSHEET tool. It does not have the word-processing/document features that a tool like Word has, where you CAN control the page numbering, using sections. Excel's numbering capability is very basic.

You might consider using Word and using OLE to link portions of your workbook.


Skip,

_[red][/red]

 

[yogia]

The problem I have is that I’m also printing all cover sheets I have between the sheets. And I do not want to have the page number on the cover sheets; however, I want them to be printed on the order of the sheets.
Thanks

Hi Joe1010:

You may opt for not having EXCEL number pages automaticlly during printing -- but key-in page number or whatever information you want printed in a preselelected cell at the top or the bottom of the page in whatever sheet you like.

So for SheetN page 1 ... you can use the following fomula ...

="Page "&2*N-1&" of 80"

and for SheetN page 2 ... you can use the following fomula ...

="Page "&2*N&" of 80"

You may be able to furthur automate by having EXCEL determine the Sheet Number formulatically.

I hope this helps.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[Joe1010]

If I understand you corr4ctly, I should manually set the footer for each page. Is this correct? For some reason, your reply is displayed with N’s

In addition, is it possible to point the footer to a cell on the sheet?
Thanks

 

[yogia]

If I understand you corr4ctly, I should manually set the footer for each page. Is this correct? For some reason, your reply is displayed with N’s

In addition, is it possible to point the footer to a cell on the sheet?
Thanks

Hi Joe1010:

Using PageNumber in a footer isn't going to get the result you want. So if you do want to print a footer with some other information, skip the option of printing pageNumbers via the footer.

And put the formula I suggested in a cell near the bottom of a page if you want the PageNumber near the bottom of the page, or in a cell near the top of the page if you would like to see the PageNumber displayed and printed at the top of the page. N, in my formula is the corresponding sheet numbersheet number.

If your sheets are numbered consecutively as Sheet1, Sheet2, Sheet3, ... all the way to Sheet20, then instead of manually keying the value of N for the pPageNumber for each sheet, you may use the follwing formula to extract the sheet number for each sheet automatically ...

=CELL("filename",A1),FIND("Sheet",CELL("filename",A1))+5,2)

It takes longer to explain than to do it. So I suggest you try it out, make whatever changes you need to make to get the result you want to get.

I hope this helps.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com