ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Continuous Page No. on all worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/44001-continuous-page-no-all-worksheets.html)

Amjad

Continuous Page No. on all worksheets
 
I have 10 Sheets in a workbook. I want each printing page to be numbered
automatically.

Example:
Sheet-1 has 12 pages and Sheet-2 has 20 pages. I want Sheet-2 pages number
to start 13 automatically or you can say after the last page number of the
previous sheet.

Dave Peterson

Select the worksheet tabs you want to print (click on the first tab and
ctrl-click on subsequent).

Then file|print



Amjad wrote:

I have 10 Sheets in a workbook. I want each printing page to be numbered
automatically.

Example:
Sheet-1 has 12 pages and Sheet-2 has 20 pages. I want Sheet-2 pages number
to start 13 automatically or you can say after the last page number of the
previous sheet.


--

Dave Peterson


All times are GMT +1. The time now is 12:36 PM.

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