Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Den
 
Posts: n/a
Default 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   Report Post  
Max
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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   Report Post  
RagDyeR
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Header and Footer Dave Excel Discussion (Misc queries) 1 March 23rd 05 08:24 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
How to automate custom footer on all tabs neal august Excel Discussion (Misc queries) 1 March 3rd 05 02:38 PM
How can I get yesterdays date in a custom footer &[DATE]-1 does . chuck Charts and Charting in Excel 1 February 17th 05 02:49 AM
Custom footer Chrissy New Users to Excel 2 December 3rd 04 09:01 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"