General discussion

  • Creator
    Topic
  • #2114139

    Excel 2000 Page Numbers

    Locked

    by gahill ·

    How can you force the page number in Headers & Footers to reset to page 1 on a group break? Data is sorted and Subtotalled by salesman. I want to page to start at 1 when the salesman number changes.

    Thank you

All Comments

  • Author
    Replies
    • #3811343

      Excel 2000 Page Numbers

      by md_hashim ·

      In reply to Excel 2000 Page Numbers

      Auto page numbering should help I guess…

    • #3434354

      Excel 2000 Page Numbers

      by bikerchic ·

      In reply to Excel 2000 Page Numbers

      Write a macro that checks the cell that contains the salesman number and compares it with the previous cell containing a salesman number. If they are equal, do nothing. If they are not, insert a page break.

      • #3495549

        Excel 2000 Page Numbers

        by gahill ·

        In reply to Excel 2000 Page Numbers

        The question was auto-closed by TechRepublic

    • #3488447

      Excel 2000 Page Numbers

      by dklippert ·

      In reply to Excel 2000 Page Numbers

      You could set up Custom Views and then print each view

      • #3495550

        Excel 2000 Page Numbers

        by gahill ·

        In reply to Excel 2000 Page Numbers

        The question was auto-closed by TechRepublic

    • #3495548

      Excel 2000 Page Numbers

      by gahill ·

      In reply to Excel 2000 Page Numbers

      This question was auto closed due to inactivity

Viewing 3 reply threads