Rows with a height of zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherrited a spreadsheet where a large number of rows (not necessarily
contigious) were hidden by changing their heights to zero.

Selecting the rows around these and trying to unhide them or selecting row
height and trying to resoze by clicking and dragging the row boarders does
not work. It's been a goto then format the row to a new height.

Is there a way to globally change the row heights that will pick up these
menicing rows with out having to sort through a couple of thousand rows to
catch them all?

Thanks
 
Assuming you want all rows to be the same height, can't you just select the
entire used range (select A1, then CTRL+SHIFT+END), then format/rows/height.
For me, with a default font of Arial 10 pt, the default row height is 12.75.
 
Back
Top