Expanding only visible groups

SteveBExcel

New Member
Joined
Aug 28, 2013
Messages
1
I have a very large spreadsheet with several groups of rows. The level 1 row in each group contains location data for a cable. The level 2 children rows contain details for that cable. When I filter the spreadsheet based on a location, all of the cables that have that location are visible but the details rows are collapsed. If I click the '2' to expand the rows, all groups in the spreadsheet expand. How do I only expand the groups with header rows that are visible?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,109,143
Messages
5,527,072
Members
409,743
Latest member
sukuto20

This Week's Hot Topics

Top