Incrementing Page Numbers in Footers

  • Thread starter Thread starter BHE
  • Start date Start date
B

BHE

In Excel 2003 I could start the footer page numbers at page 2 simply by using
the following custom footer.

Page &[Page]+1

In Excel 2007 the footer shows up as Page 11, not Page 2. Is there an easy
workaround for this change?
 
Make sure you include a trailing space character after that 1.

Page &[Page]+1_ (where _ is a space)

The same things happen in xl2003 if you don't include that space character.
In Excel 2003 I could start the footer page numbers at page 2 simply by using
the following custom footer.

Page &[Page]+1

In Excel 2007 the footer shows up as Page 11, not Page 2. Is there an easy
workaround for this change?
Click to expand...
 
Dave,

It works perfectly. Thanks for the help.

BHE

Dave Peterson said:
Make sure you include a trailing space character after that 1.

Page &[Page]+1_ (where _ is a space)

The same things happen in xl2003 if you don't include that space character.
In Excel 2003 I could start the footer page numbers at page 2 simply by using
the following custom footer.

Page &[Page]+1

In Excel 2007 the footer shows up as Page 11, not Page 2. Is there an easy
workaround for this change?
Click to expand...
Click to expand...
 
Back
Top