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
Bookmarks