Get instant live expert help on row height excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
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
I have 2 identical laptops.
I have set up a spreadsheet template which i need to use on both pc's
On pc1 the worksheet opens with a row height of 13.7
on pc2 the same worksheet opens with a row height of 13.75 which means the page breaks are in a different position?
On PC1 if i enter a row of 13.75 (to match pc2) it defaults to 13.8, i can not set it to 13.75
All the settings are the same, ie txt height, printer settings, resolution etc
Why is this?
Can i make them the same row height?
Solved by K. J. in 25 mins