Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page Numbers (Excel 2003)

    I have a 400 page spreadsheet. My pages are numbered Page 1 of 400, Page 2 of 400, etc. I want to print ONLY page 13 and I want my page number to say Page 13 of 400. How do I make that happen (without manually changing the footer for page 13)?

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

    Re: Page Numbers (Excel 2003)

    In the File | Print dialog, enter 13 in the From and To boxes in the Print Range section. On;y page 13 will be printed, with the correct page number.

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Numbers (Excel 2003)

    Actually, I tried that and it prints the entire document. I've also tried printing a selection and I get Page 1 of 1 on the footer. I've also tried selecting the print area and printing it, but that doesn't work either. I find it hard to believe that if I want to print one page out of an Excel spreadsheet, I have to change the footer manually (i.e., Page 13 of 409 pages)!

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

    Re: Page Numbers (Excel 2003)

    I don't understand that - I tried it with the settings as in the screenshot I posted, and got a printout of one page with "Page 13 of 36" (the sheet I tried it on has 36 pages when printed in its entirety). I tried it in Excel 2002 and in Excel 2003, and it worked correctly both times.

    Printing a selection or setting the print range to a single page will not do what you want - both will result in Page 1 of 1.

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page Numbers (Excel 2003)

    What do you get when you print page 13 in accordance with Hans' instructions?
    Please copy the code from your footer and post it.
    Regards
    Don

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Numbers (Excel 2003)

    Referring to the picture in Hans' <post:=663,802>post 663,802</post:> , and assuming you have selected pages From: 13 To: 13, what do you see if you click on Preview?

Posting Permissions

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