ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   page numbers in workbooks (https://www.excelbanter.com/excel-worksheet-functions/127223-page-numbers-workbooks.html)

G.W

page numbers in workbooks
 
I have multiple files with multiple worksheets, is there any way to get a
consectutive page numbers throughout all of the workbooks?



Richard O. Neville

page numbers in workbooks
 
Yes. Select all the workbooks and print them together. If you have entered a
page number in every workbook, the numbers will be consecutive. Check first
in Print Preview.

"G.W" wrote in message
...
I have multiple files with multiple worksheets, is there any way to get a
consectutive page numbers throughout all of the workbooks?





G.W

page numbers for multiple workbooks and files.
 
I attempted that course of action, but each file is printing out as 1 of 7, 1
of 3, etc. Is there any way to link the files to have a number sequence, as
the example above, 1-10?



Mike Rogers

page numbers for multiple workbooks and files.
 
G.W

You can get the page numbers to be sequential in a single workbook by
Grouping the worksheets and then printing. You could try opening all your
workbooks, grouping each one and then print them all at once. Be sure to
"ungroup" before making any changes.
I have no idea whether or not this will work but I thought it might be worth
a try.

Mike Rogers

"G.W" wrote:

I attempted that course of action, but each file is printing out as 1 of 7, 1
of 3, etc. Is there any way to link the files to have a number sequence, as
the example above, 1-10?




All times are GMT +1. The time now is 01:04 PM.

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