sort changes row height

[Christyr]

How can I keep row height from changing when I perform a sort? When I sort, I
lose sight of some of my information in my cells and then have to resize my
row height when I re-sort.
Thank you for your help.

 

[Simon Lloyd]

How can I keep row height from changing when I perform a sort? When I
sort, I
lose sight of some of my information in my cells and then have to
resize my
row height when I re-sort.
Thank you for your help.Well without VBA you could simply click the "Home" square (next to A and

above 1 top left of your worksheet) then press and hold Alt then press
O, R & A one after the other whilst holding Alt, this will autofit your
rows, or using the mouse, click the home square, Format, Rows, Autofit.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)