ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page Numbering in Consecutive Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/162060-page-numbering-consecutive-worksheets.html)

Sea Urchin

Page Numbering in Consecutive Worksheets
 
I have a document consisting of a number of worksheets. Because of the
layout it is not possible to do it in one worksheet. I want the page numbers
to work consecutively through the whole document, rather than just in each
worksheet. Is there anyway I can link the footers together?

Trevor Shuttleworth

Page Numbering in Consecutive Worksheets
 
Try grouping the sheets (selecting them all) before you print. I think the
page numbers will increment throughout the combined document.

Regards

Trevor


"Sea Urchin" <Sea wrote in message
...
I have a document consisting of a number of worksheets. Because of the
layout it is not possible to do it in one worksheet. I want the page
numbers
to work consecutively through the whole document, rather than just in each
worksheet. Is there anyway I can link the footers together?




Needs Help

Page Numbering in Consecutive Worksheets
 
Thank you Trevor. This worked for me! Glad you posted so others can benefit.

"Trevor Shuttleworth" wrote:

Try grouping the sheets (selecting them all) before you print. I think the
page numbers will increment throughout the combined document.

Regards

Trevor


"Sea Urchin" <Sea wrote in message
...
I have a document consisting of a number of worksheets. Because of the
layout it is not possible to do it in one worksheet. I want the page
numbers
to work consecutively through the whole document, rather than just in each
worksheet. Is there anyway I can link the footers together?






All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com