Help!

How do I create columns that expand and collapse in Excel?

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  Concatenate and Mail Merge  
Author Message
Curious Excel ER
External


Since: Jun 10, 2005
Posts: 1



PostPosted: Fri Jun 10, 2005 12:21 pm    Post subject: How do I create columns that expand and collapse in Excel?
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

I would like to copy the expand and collapse feature in another part of my
worksheet. I am using the rolling forcast and buget template. Can this be
done?
Back to top
Ron Coderre
External


Since: Apr 02, 2005
Posts: 738



PostPosted: Fri Jun 10, 2005 1:34 pm    Post subject: RE: How do I create columns that expand and collapse in Exce [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If I understand what you're asking, try this

1)Select the columns to be expanded/collapsed
2)Data>Group and Outline>Group

Does that help?

--
Regards,
Ron
Back to top
RagDyer
External


Since: Jun 14, 2004
Posts: 762



PostPosted: Fri Jun 10, 2005 8:31 pm    Post subject: Re: How do I create columns that expand and collapse in Exce [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Lookup "Outline" in the Help files, and check out this link:

http://tinyurl.com/6uc2p

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Curious Excel ER" wrote in
message
> I would like to copy the expand and collapse feature in another part of my
> worksheet. I am using the rolling forcast and buget template. Can this be
> done?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum