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

I have an excel sprea开发者_如何学Godsheet 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?

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

Assuming you are using 2003 or 2007:

1. Highlight all of the rows.
2. Right-click over top of one of the row numbers.
3. Click the Row Height menu item and set it to your desired height.

Select any cell in the data range, then Ctrl+Shift+L(apply data filter).

All rows with zero row height will appear. Can use Ctrl+Shift+L to trigger data filter off.