Excel Experts-COME IN!!

Posted By Message

zeta1996
YUMMY!

Member since 9/06

2365 total posts

Name:

Excel Experts-COME IN!!

I know I have done it before, but I want to creat a "tree chart" where I have one header and then there is information underneath that I can collapse with a little + sign. Does that make sense? Please help me...I have tried EVERYTHING!

Posted 7/24/08 11:27 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Christine
2nd verse same as the 1st

Member since 5/05

15287 total posts

Name:

Re: Excel Experts-COME IN!!

Are you talking about subtotals?

Posted 7/24/08 11:30 AM
 

zeta1996
YUMMY!

Member since 9/06

2365 total posts

Name:

Re: Excel Experts-COME IN!!

Well the cells all contain text. There are no numbers.
I am looking to do something like this:
Design Phase
1. Draw
2. Approve

And the 1 and 2 would be able to be hidden with a plus sign to expand when necessary.

Posted 7/24/08 11:51 AM
 

PreshusSmurf
So in love with my little guys

Member since 1/07

2963 total posts

Name:
Jess

Re: Excel Experts-COME IN!!

Highlight the columns you want to hide.

Then from the menu bar at the top of your screen:

Data > Group and Outline > Group

HTH! Chat Icon

Posted 7/24/08 12:46 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel Experts DRMom 7/9/08 5 Families Helping Families ™
calling all the IF experts/researchers/scientists rose825 3/13/06 21 Infertility
chart experts I have a question... jeandan 3/13/06 6 TTC
experts needed... jeandan 3/8/06 8 TTC
Celebrity Experts- Can you please tell me who this is justthe4ofus 2/21/06 43 Families Helping Families ™
Temp Experts.. Opinions Wanted.. justme1 2/5/06 6 TTC