Excel row height issue after filtering

Hi, I want to ask if is there any solution on my issue on Excel filtering (I will describe my issue below)?

My problem is like this:

I tried to unfiltered my data after I have filtered my data, I realised that several data began to hide (i.e the row height of some data become 0).

I tried to select all the data and unhide the data, but it still hide the data (i.e the row height of some data become 0).

Then, I can only manually drag the row height to see my data or double click the row height manually to see my data.

My problem is, when I manually drag the row height to see my data or double click the column height manually to see my data, is very time-consuming. 

I would like to ask if there is any time-saving technique to solve my problem?

Thank you.