| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Page Numbers
How can I add page numbers to the center footer with a given format -such as
"Page X of Y"- when my footer has already text? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Page Numbers
Excel version?
If 2003, go to File Page Setup Header/Footer tab, click "Custom Footer", click in the Center Section, click the end of your text and press the [+] button (the second button from the left) then type " of " and click the [++] button (the third button from the left). Does that work, or did you want a programmatic solution? --JP On Oct 2, 2:43*pm, Jess wrote: How can I add page numbers to the center footer with a given format -such as "Page X of Y"- when my footer has already text? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Page Numbers
I require the programmatic solution for this problem.
Thanks, Ron "JP" wrote: Excel version? If 2003, go to File Page Setup Header/Footer tab, click "Custom Footer", click in the Center Section, click the end of your text and press the [+] button (the second button from the left) then type " of " and click the [++] button (the third button from the left). Does that work, or did you want a programmatic solution? --JP On Oct 2, 2:43 pm, Jess wrote: How can I add page numbers to the center footer with a given format -such as "Page X of Y"- when my footer has already text? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can Enter Page Numbers and/or page ranges separated by commas. | Excel Discussion (Misc queries) | |||
| Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
| adding page numbers | Excel Worksheet Functions | |||
| Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
| Converting test to numbers and adding into a summary page | Excel Worksheet Functions | |||
Linear Mode
