Hello everyone,
i need help regarding page number across worksheets..
Ex:
in first work book i have 3 pages and i need to continue with page 4 on the second sheet..
Thanks
Hello everyone,
i need help regarding page number across worksheets..
Ex:
in first work book i have 3 pages and i need to continue with page 4 on the second sheet..
Thanks
Hi,
I had the same problem and solved it in the following way:
1. insert page numbers in the normal way as a footer. Each worksheet is then numbered 1-xx in the normal way.
2. mark the first worksheet tab and select the page layout menu, open the page setup menu with the little arrow in the bottom left corner. This gives you a page setup box where you can tell excel which page number you want to start from, I assume this is 1.
3. Mark all the other wotksheet tabs (not the first tab) and do the same again, only this time make sure the first page number box is blank. If you then go back in afterwards you can see that excel converts this to "automatic".
4. print the whole workbook as normal. The page numbers will be sequential from the firrst number you gave for worksheet1.
I hope this helps.
Select both sheet tabs before printing then the page numbering will be automatic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks