![]() |
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? |
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? |
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? |
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