Currently when I filter rows and remove hidden text, I use the document inspector to 'remove hidden rows and columns'.
Some of my sheets have thousands of rows I am trying to remove, and it takes a painstaking amount of time to remove and freezes my excel temporarily (5-10min).
Does anyone know any faster or more efficient ways at removing whole rows faster?
Bookmarks