I usually double click on the divider between row numbers to automatically set the row height. This usually works, but sometimes it leaves cells with their content truncated.
This sanitised worksheet shows the issue, any suggestions for why this happens or how to avoid/correct it?
Auto row height not working well
-
- Administrator
- Posts: 12577
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Auto row height not working well
You do not have the required permissions to view the files attached to this post.
StuartR
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Auto row height not working well
This is a persistent problem in Excel. The autofit algorithm is far from perfect, and there is no solution or workaround except manually adjusting the row heights.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12577
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
-
- 3StarLounger
- Posts: 201
- Joined: 02 Feb 2010, 23:58
Re: Auto row height not working well
Try changing the zoom factor 80% then back to 100% or just zoom to selection then back to 100%.
-
- Administrator
- Posts: 12577
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe