Geek asks and answers

Change row heights in excel when hundreds were set to 0

I have an Excel spreadsheet with a list of hundreds of users. Many lines are set to a height of 0. I want all of them to be the same, so that I can see them all. I would prefer not to go through each line and drag them with a height of 0 so that I can see them.

What should I do?

+4
source share
3 answers

Select all cells and double-click the resize icon in the columns.

+17
source

Assuming you are using 2003 or 2007:

  • Select all the lines.
  • Right-click on one of the line numbers.
  • Select the menu item "Row Height" and set it to the desired height.
+3
source

, Ctrl + Shift + L ( ).

All rows with zero height will appear. You can use Ctrl+ Shift+ Lto turn off the data filter.

-1
source

More articles:


All Articles