ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   set up page numbers (https://www.excelbanter.com/excel-programming/297332-set-up-page-numbers.html)

71paolo71[_3_]

set up page numbers
 
Dear friends
Does anyone know how to set up page numbers in the footer that wil
print continuously across worksheets preserving the print area alread
made? I give you a example. I have 3 worksheets: WS1, WS2, WS3. I
every worksheet there are 3 pages to print. The print area is alread
defined in each worksheet but, unfortunately, in page setup for eac
worksheet is defined a different proportion (57% of normal dimension
65% and 68%). I would not change this proportion and I would like t
obtain this result:
WS1:page1, WS1page2, WS1page3, WS2page4, WS2page5…..
I tried to select all sheets and to setup page number in the footer bu
the result was not good because the print area was changed.
Someone can help me?
Thank yo

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 05:15 PM.

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