Expand/Collapse Row functionality?

[Actsh]

Hi All,

How do I add collapse/expand functionality for rows to the left hand side of the row numbers. I want to build a project plan using Excel with the ability to hide (collapse) lower level tasks. I've seen this in some spreadsheets but have not been able to work out how to implement.

Thanks,
Actsh B-)

 

[BlueHorizon]

Hi,
It's the Outline feature on the Tools menu. Sort your columns so you group all like information together then use this feature to produce the expand/collapse rows you're looking for.
HTH,


Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[Actsh]

Cheers BlueHorizon - Spot on. Found the option in under Data - Group & Outline.