Good Afternoon,

I have grouped multiple sets of rows in one of my spreadsheets so that I can maximize and minimize certain sections we do not need/use at the moment.

The problem is that if I use a drop down filter to search for a certain section, when i clear the filter, that seems to open up all of the minimized grouped rows?
Is there a way for excel to remember the minimized sections?

Could a Macro be used to keep the certain sections minimized unless the user opens them?

Tom