How can I fit row heights to the data?

[Jeff Heikkinen]

(Already posted to .setup, but no replies so far.)

I have an Excel file with several sheets that are basically glorified
laundry lists; all that's in any given cell is text or a simple number
that I don't need to do any calculations on. (It's information on some
of the abilities available to characters in an RPG I run, if that helps
anyone visualise it.)

Here's the problem: whenever I sort this list or otherwise appreciably
change the order of it, it screws up my row heights. Some rows end up
too small for the text in them while others have huge amounts of white
space in the top. I am 100% uninterested in going through and manually
fixing them all every time I do this. How do I get each row to
automatically be just large enough to display all the text in whatever
cell ends up the "tallest"?

 

[Frank Kabel]

Hi
have you tried: Format - rows - autofit?

 

[Jeff Heikkinen]

Frank Kabel, worshipped by llamas the world over, wrote...

Hi
have you tried: Format - rows - autofit?

I had that set up originally, and assumed it would still apply. I
turned it back on, and it helped a lot, but some rows still have lots of
white space at the top.