How do you make sub-groups within groups, similar to a Windows Folder
structure?

- Grand Parent 1
- Parent 1
Child 1
Child 2
- Parent 2
Child 3
Child 4
- Grand Parent 2
- Parent 3
Child 1
Child 4
- Parent 4
Child 5

I want to be able to collapse or expand Parents and Grand parents individual
of each other (Obviously, to see a parent, I'd need to have the Grand Parent
expanded). Exactly like the Folders behave in Windows Explorer



"galimi" wrote:

Bob,

This feature is located under the Data menu, Group and Outline, Group and
select Rows or Columns. You should highlight the rows or columns that you
wish to group prior to clicking on that feature.

http://HelpExcel.com

"bob sacco" wrote:

I already did this in an old excel worksheet but I CAN'T remember HOW I DID IT.

The result is a (plus) + and a (minus) - sign at the top of the worksheet in
row 1 at the location where you want your selected columns to either expand
or collapse.

I need to once again implement this handy formatting trick but for the life
of me remember how I did it....so frustrating!

Anyone out ther know how to do this?