change the height of a rows in excel when hundreds have been set to 0

Question

I have an excel spreadsheet with a list of hundreds of users. A lot of the rows have been set to height 0. I want to set all of them to the same value so I can see all of them. I'd rather not have to go through every row and drag the ones with height 0 down so I can see them.

What do I do?

Answer 1

Mark all cells and double click when the resize icon is visible over the columns.