Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting and Page breaking (Excel 97/SR2)

    I am being provided a list of employees in an excel format. This list contains multiple columns of employee related data including supervisor name.

    I am having trouble figuring out a way to break the list so that it would print each supervisors employees as a group on one page.

    I have sorted the entire list by supervisor name, but am looking for a way to automatically add page breaks whenever the supervisor name changes. What would be the best way to go about this?

    Thanks in advance for any help.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sorting and Page breaking (Excel 97/SR2)

    You could use the subtotal feature (Data, Subtotals).

    This gives you the opertunity to break a sorted list where a chosen column (supervisor in your case) changes value. You could do a subtotal To Count the supervisor field. The subtotal feature does give you the facility to place a page break for each group.

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Hunt Valley, Maryland, USA
    Posts
    88
    Thanks
    58
    Thanked 0 Times in 0 Posts

    Re: Sorting and Page breaking (Excel 97/SR2)

    Steve:
    If you haven't done so already, move the field (column) containing the supvrs to Col. A. If necessary, sort again. As you probably know, you may sort on (i) Supervisor, then (ii) some other field, then (iii) some other field. I usually sort by supvr, then lastname, then firstname.
    Key point: Make sure that your file is laid out (set up) as a data list, with the simple elements of a database as defined in the Excel 97 help window. Otherwise, the following steps probably won't work.
    With the cursor somewhere inside the list, click Data | Subtotals. You will then see the 'Subtotal' dialog box. In addition to whatever other things you might wish to check, check the box 'Page break between groups'.
    That's it.
    Let me know how it comes out, OK?

Posting Permissions

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