Incrementing Page Numbers in Footers

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?
 
D

Dave Peterson

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...
 
B

BHE

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Page Numbers on Worksheet in Excel 2007 6
Custom Page numbers in the footers 1
can I use letters as page numbers in footer 1
Create a Standard Footer 2
Printing Excel File Custom Properties in the Footer 3
How do I keep all page footers unique with a page number on all pa 1
How can I add letters to page numbers in Excel. 2
Consecutive Numbered Pages 2

Top