ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create columns that expand and collapse in Excel? (https://www.excelbanter.com/excel-worksheet-functions/30195-how-do-i-create-columns-expand-collapse-excel.html)

Curious Excel ER

How do I create columns that expand and collapse in Excel?
 
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?

Ron Coderre

If I understand what you're asking, try this

1)Select the columns to be expanded/collapsed
2)DataGroup and OutlineGroup

Does that help?

--
Regards,
Ron


RagDyer

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" <Curious Excel 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?




All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com