Nest cells in Excel 2010

I was directed here from Stack Overflow... hope you guys can help

I have been looking into trying to nest cells in Excel, much like how the folder tree system works in File Explorer, or the folder system in Outlook.

Further examples would be having the little box with a '+' in it to expand the selection, then the '-' to contract. I've searched Google to look for any help but couldn't really find anything, perhaps this means it cannot be done but thought I'd ask here to get some expert advice.

Thanks

Someone in Stack Overflow mentioned Outlines, which I'm currently looking at

EDIT: Outlines worked perfectly.

1 Answer

Select the rows you want to nest together and then, in the Data ribbon, click Group.

A new column appears to the left of the row headers. Clicking the - collapses the rows. Clicking the + expands the rows.