Get instant live expert help on I need help with excel autofit row height

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am trying to convert a column of different excel date formats to one format, and properly autofit row height after - however even if I format cells - custom to 'ddd, mmm dd, yyyy \at h:mm AM/PM' (the format I want), it does not change. Autofit row height also does not work. The sheet and cells are not locked. The row heights in many cases have been manually adjusted.
Solved by A. E. in 20 mins
how do I auto fit row height? I have tried format & auto fit row height but this doesn't change the row height.
Solved by E. E. in 17 mins
How to prevent auto fit row height in Pivot table
Solved by K. W. in 12 mins
I have an Excel file with approx 4000 rows. Suddenly some rows disappeared. They don't seem to be hidden because I can't unhide them. They seem to have a row height of 0 but I can't adjust the height for multiple rows. When I select a row range that includes them and adjust the height to >0. This won't make them appear. I can 1 by 1 drag their height but since more then 1000 rows are included this is impossible.
Solved by C. A. in 13 mins
Sometimes I can't adjust the row height on excel by clicking inbetween cells. It will autoadjust some cells but not all. The attachment shows how row 61 does not adjust.
Solved by V. H. in 11 mins