Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel issue

  • 22-07-2011 11:16AM
    #1
    Misticles
    Registered Users, Registered Users 2 Posts: 13,746 ✭✭✭✭


    I had to add in two new worksheets to an excel book and now the page numbering in the footer is all off.

    The new worksheets are starting at page 2 instead of continuing on from the previous sheet number..

    Any ideas how I fix these?

    Thanks


Comments

  • #2
    homer911
    Registered Users, Registered Users 2 Posts: 5,067 ✭✭✭homer911


    If there is a way to fix this, I'd like to know too.

    Have you hardcoded a page number or used the page number option?

    As far as i can see, page numbers are unique to each sheet.

    If you are creating a PDF of the output from all sheets, you will need to hard code the page numbers on each sheet (at least thats what I do)

    As for the page number starting at page 2 - are you sure you dont have a page break hidden in there somewhere?


  • #3
    Misticles
    Registered Users, Registered Users 2 Posts: 13,746 ✭✭✭✭Misticles


    homer911 wrote: »
    If there is a way to fix this, I'd like to know too.

    Have you hardcoded a page number or used the page number option?

    As far as i can see, page numbers are unique to each sheet.

    If you are creating a PDF of the output from all sheets, you will need to hard code the page numbers on each sheet (at least thats what I do)

    As for the page number starting at page 2 - are you sure you dont have a page break hidden in there somewhere?

    Gah!!

    I selected all sheets...

    Viewed Header + Footer
    Page Tab

    Put Auto in the box

    BUTTTT it made all my headers the same :( had to go in manually and change them all back.

    you can do above but don't write auto, simpley enter the number the page is and you'll be fine.

    I learned the hard way :o


Advertisement