Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Queensland, Australia
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page numbers in footer (Office XP)

    Hi
    This may be very simple but I can't seem to find an answer anywhere.

    I have a file that has 5 worksheets each with 4 pages.
    When I print the entire workbook I want the footer to should what page number of the total number of pages across all worksheets?
    My problem is I can't get the footer to show the total number of pages (in the entire workbook).
    I'm sure there is a simple answer
    Thanks for your help in anticipation
    Dax


  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in footer (Office XP)

    Use FILE==>PAGE SETUP==>HEADER/FOOTER==>CUSTOM FOOTER and from there it is just a matter of selecting the options you want.

    HTH

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Queensland, Australia
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in footer (Office XP)

    Thanks for your response Preston, however I did this previously but it only puts in the total pages for the selected worksheet. I was after a way to get all the pages in the workbook as the total number of pages

    Cheers
    Dax


  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in footer (Office XP)

    Use &[Page]& OF&[Pages].

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in footer (Office XP)

    If you only have one worksheet selected, that is all the pages that are going to be printed. You have to select all of the worksheets. If you don't want to actually print all of the pages, than control that in the print dialog box.
    Legare Coleman

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page numbers in footer (Office XP)

    Have a look at this thread

Posting Permissions

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