Hello everyone,
I've been using excel for awhile now and I've yet to find a solution to this one problem that I keep having.
Does anyone know how I can keep Group rows that have been collapsed from expanding every time I filter data in one of the columns?
It never seems to fail when I apply a filter to a column the rows automatically expand. It would be perfect if i can keep the rows from expanding and just keep them collapsed.
Thank you!
Bookmarks