E
Els
In several Excel templates I have cells with wrapped text (but no merged
cells).
In some workbooks the autofit function for the row heights works fine, but
in others I miss half a line (or more).
I tried several things to find out what causes the difference between the
workbooks.
· If I copy the whole worksheet in which autofit works fine to a new
workbook, it goes wrong in the new one
· As far as I can see all the Excel options in both workbooks are
the same
· The font size is 10.5 in all the workbooks. Changing it in 10 or
11 solves most of the times the problem, but is not the preferred option.
I do hope anyone can tell me why autofit the rowheight does work in some
workbooks and not in others?
Or at least how I can solve this problem.
Thanks Els
cells).
In some workbooks the autofit function for the row heights works fine, but
in others I miss half a line (or more).
I tried several things to find out what causes the difference between the
workbooks.
· If I copy the whole worksheet in which autofit works fine to a new
workbook, it goes wrong in the new one
· As far as I can see all the Excel options in both workbooks are
the same
· The font size is 10.5 in all the workbooks. Changing it in 10 or
11 solves most of the times the problem, but is not the preferred option.
I do hope anyone can tell me why autofit the rowheight does work in some
workbooks and not in others?
Or at least how I can solve this problem.
Thanks Els