ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do i get page 1 of 1 in a custom Footer (https://www.excelbanter.com/new-users-excel/21185-how-do-i-get-page-1-1-custom-footer.html)

Den

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

Max

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




Max

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



RagDyeR

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





All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com