| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Page numbers in the footers | Excel Discussion (Misc queries) | |||
| Printing Headers on only first page and Footers on only last page | Excel Discussion (Misc queries) | |||
| Page Numbers in headers/footers | Excel Discussion (Misc queries) | |||
| Incrementing numbers | Excel Worksheet Functions | |||
| Incrementing numbers for every page printed | Excel Discussion (Misc queries) | |||
Linear Mode
