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?

Solution 1

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

Solution 2

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.

Comments

[help-info.de]

There are other answers that provide the OP's question, and they were posted some time ago. When posting an answer, please make sure you add either a new solution, or a substantially better explanation, especially when answering older questions.

[user1844933]

saved my time, both auto fit and manual height not worked...