Dbast
asked on
Paginate worksheets in an Excel 2010 workbook
I have a workbook with 50 worksheets -- one for each state. I need pagination to start on page 9.
If I use Page Setup and specify 9 as the first page number, every worksheet thereafter shows page 9. If I set Auto as the first page number, it starts with 1 and every page numbers sequentially thereafter. It makes no sense
If I use Page Setup and specify 9 as the first page number, every worksheet thereafter shows page 9. If I set Auto as the first page number, it starts with 1 and every page numbers sequentially thereafter. It makes no sense
ASKER
Remarkably -- at least to me -- doing &[Page]+8 gives me a starting page number of 18 on the odd-numbered pages. But the even-numbered pages are now numbering properly. So when I do print preview, my page numbering looks like this:
18 - 10 - 38 - 12 - 58 - 14 - 78 etc.
18 - 10 - 38 - 12 - 58 - 14 - 78 etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for calling my attention to the space at the end; I hadn't noticed that, and that in fact did the trick. And now I do have different odd and even pages, and each one is paginating correctly.
Cannot thank you enough -- there is no way I would have figured out the need for that space!
Cannot thank you enough -- there is no way I would have figured out the need for that space!
ASKER
Never would have figured this out without Michael74's help.
Thank you, happy to help
"&P+8 " (without the quotation marks
http://support.microsoft.com/kb/48198/en-us