ExcelBanter - Incrementing Page Numbers in Footers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Incrementing Page Numbers in Footers (https://www.excelbanter.com/excel-discussion-misc-queries/193246-incrementing-page-numbers-footers.html)

BHE

Incrementing Page Numbers in Footers

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?

Dave Peterson

Incrementing Page Numbers in Footers

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.

BHE wrote:

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?

--

Dave Peterson

BHE

Incrementing Page Numbers in Footers

Dave,

It works perfectly. Thanks for the help.

BHE

"Dave Peterson" wrote:

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.

BHE wrote:

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?

--

Dave Peterson

All times are GMT +1. The time now is 03:51 AM.