Hidden Rows Appear when Ungrouped

[kannon8833]

Morning -

While not a big problem in my spreadsheet I am always inquisitive in using Excel. So, here is what is happening.

I have 4 rows of data. One row is hidden. All four rows are Grouped together.

When I Ungroup the data rows to see details I was hoping to see only 3 rows of data (the 4th row remain hidden). But I see all 4 rows.

Is there a way to keep the row hidden I want as I go from Group/Ungroup/Group views??

Thanks

Kannon

[queuesef]

How about using a Filter? Once your data is in a 'Table' format you can filter your data as you wish.