locked
Excel 2010 - Working with X of Y page numbering RRS feed

  • Question

  • Hi

    I have a document that I use x of y page numbering on. However the first 3 pages are the front cover, tables of contents etc. The numbering starts on the fourth page with 1 of 10. Unfortunately this includes all the pages in the document and not the pages from the fourth page onwards. Is there any way I can chage the numbering so it excludes the first 3 pages in the numbering?

    Thanks,

    Viv


    Viv Haig

    Tuesday, October 23, 2012 5:21 PM

Answers

  • Fabulous Hans, that worked.

    Many thanks.

    Viv


    Viv Haig

    • Marked as answer by VHaig Wednesday, October 24, 2012 10:29 AM
    Wednesday, October 24, 2012 10:29 AM

All replies

  • You posted this in the Word IT Pro forum, but the subject mentions Excel 2010.

    Is your question about a Word document or about an Excel workbook?


    Regards, Hans Vogelaar

    Tuesday, October 23, 2012 7:05 PM
  • Hi,

    Assume you work in Word application and insert the section break:

    http://blogs.office.com/b/microsoft-word/archive/2010/08/06/insert-page-x-of-y-page-numbers-in-just-one-section.aspx

    You should be able to change the code of field "Y" from {NumPages} to {SectionPages}

    Best regards,


    Rex Zhang

    TechNet Community Support


    • Edited by Rex Zhang Wednesday, October 24, 2012 7:42 AM
    Wednesday, October 24, 2012 7:41 AM
  • Tough day yesterday - I should have put Word 2010 and not Excel!

    Viv Haig

    Wednesday, October 24, 2012 8:56 AM
  • OK.

    Insert a section break at the end of page 3 (if you don't have one already).

    If you have only one section after the first one, you can use the SectionPages field to display the number of pages:

    - Press Ctrl+F9 where you want the number of pages to insert field brackets { }
    - Type SectionPages between the brackets: { SectionPages }
    - Press F9 to hide the field code.

    If you have multiple sections after the first one, you can do the following:

    - Press Ctrl+F9 to insert field brackets.
    - Type =
    - Press Ctrl+F9 again.
    - Type NumPages
    - Position the insertion point after the first closing bracket }.
    - Type -3
    - You should now see { ={ NumPages }-3 }
    - Press F9 to hide the field codes.


    Regards, Hans Vogelaar

    Wednesday, October 24, 2012 9:13 AM
  • Fabulous Hans, that worked.

    Many thanks.

    Viv


    Viv Haig

    • Marked as answer by VHaig Wednesday, October 24, 2012 10:29 AM
    Wednesday, October 24, 2012 10:29 AM