Excel - rows compressed/squashed after filtering

A user has a spreadsheet and filters on all of the columns. They find that when they filter by one of the columns, and then remove the filter by selecting "select all", some of the rows remain "squashed" once the column is unfiltered. By this, I mean that the rows reappear, but some of them are very tightly condensed and have to be expanded.

Afraid I can't provide a copy of the spreadsheet due to data protection reasons, but any suggestions of possible causes would be appreciated.


I think it is almost certainly because you still have a filter applied on one or more of the other columns.

Make sure all filters are unchecked and it should return to normal