Get instant live expert help on I need help with excel auto 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

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
auto-resize a cell's width and height to a pasted pictures dimensions automatically
Solved by M. Q. in 21 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