sorting changes row height

[Guest]

I have set the row heights for the rows in my spreadsheet exactly as I want
them - different rows have different heights. When I sort the spreadsheet,
which I do every day or so, Excel changes some of the row heights. How can I
prevent this?

 

[Dave Peterson]

The rowheight stays with the row.

If I had to do this, I'd add a helper cell per row -- some kind of indicator.

then sort my data,
autofit all the rows
and look for that indicator and adjust the rowheight of those rows.

 

[Guest]

Hi Dave,
Thanks for your post. I am having the same problem. Did not have this
problem with previous version of Excel! Anyway...can you explain more about
the helper row? I've used Excel for years but never heard of that.

 

[Dave Peterson]

It's just another column.

Put some kind of indicator in that column (Yes/No, True/False, anything that
would indicate what you want to do later.)

Then sort your data (but include that column with the indicator in the range
sorted).

Now all your rowheights are mixed up. Select all the cells and autofit the
rowheights.

Filter by that helper column so that you only see Yes, True (or whatever).

Select those visible rows and adjust the rowheight (double it???).

Then data|filter|showall
(or remove the filter.)

(Hide or delete the helper column if you don't need it anymore.)