+ Reply to Thread
Results 1 to 3 of 3

Setting page number to a different start in footer

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,705

    Setting page number to a different start in footer

    Hello,
    I am trying to set a next page on my second sheet from the sheet1.

    My first sheet has the page ending in 170 so then on my second sheet I have this code in the footer:
    &[Page]+171.

    My second sheet has about 50 pages. So the 1st page on sheet2 should printed 171, 172, 173, etc.

    But when I print them it doesn’t come out as it should be. What code should I used to print consecutively.

    Thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,675

    Re: Setting page

    Try adding a space after 171 in the footer code.

    If you print both sheets at the same time you will get consecutive numbering by just using &[Page] in both footers. Then you won't have to make changes if the number of pages changes.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,705

    Re: Setting page number to a different start in footer

    Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Format page number in excel footer to start at a specific page #
    By straitctrydncr in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 08:00 AM
  2. [SOLVED] How do I start Excel Footer on 2nd page?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 11:05 PM
  3. [SOLVED] How do I start Excel Footer on 2nd page?
    By dicfor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 PM
  4. [SOLVED] How do I start Excel Footer on 2nd page?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-06-2005, 08:05 PM
  5. [SOLVED] How do I start Excel Footer on 2nd page?
    By dicfor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  6. [SOLVED] How do I start Excel Footer on 2nd page?
    By dicfor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. How do I start Excel Footer on 2nd page?
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 05:05 AM
  8. How do I start Excel Footer on 2nd page?
    By dicfor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1