Expanding Groups is Unhiding Rows Previously Hidden

[jewkes6000]

I have groupings set up to expand and collapse groups of rows. However, I also want to be able to hide certain rows and keep them hidden when using the groups. What's happening is I will hide a row which is part of group, but then when I collapse and then expand that group, the previously hidden rows reappears. Is there a solution to this? Or is it just an Excel thing I have to deal with?

You can see in the images below that rows 226 and 227 have "hide" in the middle column, which makes these rows be hidden when I run a macro. However, when I collapse this grouping (shown in the other image), and then expand the grouping again, rows 226 and 227 reappear as shown in the first image, thus making me run my macro again to hide them.

 

[John_w]

I don't think there is a way to keep the rows hidden when you expand the group.

Instead of hiding the rows, a possible workaround is to create multi-level groups. Group the 'hide' rows first (with a macro), then group the other rows.