Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is there a way to collapse rows like in MS Project (Excel 2000)

    I have a habit of creating basic Excel worksheets that end up looking like an outline. I'd like to know if there is a way to bring the +/- expand/collapse idea that I like so much in MS Project over to Excel. I want to be able to highlight a bunch of rows, implement the trick that I hope this post will yield, and end up with the plus sign next to the first line of the collection. Thanks.

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

    Re: Is there a way to collapse rows like in MS Project (Excel 2000)

    The only thing that comes to (my) mind is Subtotals. If you have a table, you can add subtotals on column(s) (Data menu, Subtotals option); the column(s) must be ordered for this to work. "Subtotals" do not necessarily sum data, you can also compute count, average, min, max, ...
    Excel will display outline buttons (+/-) for each subtotal level.

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a way to collapse rows like in MS Project (Excel 2000)

    Thanks Hans, Subtotals is functionality that I didn't think to try. It is effective, and short of any other alternative, I'll use it. However, my ideal solution would be one that left the plus sign somwhere other than in this new left margin area that I now see. I'd prefer that the plus sign show up perhaps just preceding the label of the "column" cell. I also could do without the extra line and text that shows up as "Grand Total". Any additional thoughts that you might have would be welcome.

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Is there a way to collapse rows like in MS Project (Excel 2000)

    You will also like the Group and Outline feature in Excel. Baarns Publishing has a dowloadable workbook which walks you through this feature. Looks like it is written for XL97, but I don't remember any changes in XL2K. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

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

    Re: Is there a way to collapse rows like in MS Project (Excel 2000)

    I don't think that you can get Excel to place the +/- buttons elsewhere.
    You can remove the Grand Total if you wish, although the +/- for it won't disappear.

Posting Permissions

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