Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i get page 1 of 1 in a custom Footer
It's only a simple thing but i don't know how to get page 1 of 1 without
typing it in myself can anybody help Thank's |
#2
|
|||
|
|||
Click File Page Setup Header/Footer tab Custom Footer
Place the cursor within the desired section (Left - Centre - Right) and then put*:: &[Page] of &[Pages] Click OK OK *You can also click the 2 buttons next to the "A" button in the Footer dialog to insert the "&[Page]" and the "&[Pages]" parts. The centre part: " of " is keyed-in manually -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Den" wrote in message ... It's only a simple thing but i don't know how to get page 1 of 1 without typing it in myself can anybody help Thank's |
#3
|
|||
|
|||
and then put*:: &[Page] of &[Pages]
Slight tweak to the above, to sync with your subject line ..: put instead: Page &[Page] of &[Pages] (an additional "Page " part placed in front) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
#4
|
|||
|
|||
Then, there's always the option to use one of the default XL "already
constructed" footers, one of which will give you: Page 1 of 1 <File <PageSetUp <Header / Footer tab, And under "Footer", Expand the footer box to display default footers. Just click on the one of your choice to have it *automatically* inserted in your footer. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Max" wrote in message ... and then put*:: &[Page] of &[Pages] Slight tweak to the above, to sync with your subject line ..: put instead: Page &[Page] of &[Pages] (an additional "Page " part placed in front) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Header and Footer | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
How to automate custom footer on all tabs | Excel Discussion (Misc queries) | |||
How can I get yesterdays date in a custom footer &[DATE]-1 does . | Charts and Charting in Excel | |||
Custom footer | New Users to Excel |