I have an Excel file with approx 4000 rows. Suddenly some rows disappeared. They don't seem to be hidden because I can't unhide them. They seem to have a row height of 0 but I can't adjust the height for multiple rows. When I select a row range that includes them and adjust the height to >0. This won't make them appear. I can 1 by 1 drag their height but since more then 1000 rows are included this is impossible.
Solved by C. A. in 13 mins