Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Page of Pages in a Cell (xp-pro - office 2003)

    good morning experts...

    how can i display the number of pages (Page 1 of 6 Pages), for example, in a cell rather than in the header/footer?!

    thank you very much...

    best,
    wolfgang

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page of Pages in a Cell (xp-pro - office 2003)

    I think that'll be difficult, since Excel, unlike Word, doesn't repaginate automatically in the background.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Page of Pages in a Cell (xp-pro - office 2003)

    hi hans...

    thank you very much for you quick answer...

    if you go to page setup - print preview - all pages will be shown...

    i believe that once upon a time there was an excel4 macro or something like that which allows such a task...but i may be wrong...

    best,
    wolfgang

  4. #4
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Page of Pages in a Cell (xp-pro - office 2003)

    hi hans...

    nobody has ever left this forum without a profound answer....

    have a great day and thanks again...

    best,
    wolfgang

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Page of Pages in a Cell (xp-pro - office 2003)

    Thanks for jogging my memory.

    See Page Of Pages in a Cell on Dick Kusleika's Daily Dose of Excel blog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •