NarR
04-25-2017, 04:24 AM
Hello,
is there a way to get rid of the extra row height when the first line in the cell is full and Word Wrap activated?
See the Screenshot in the Attachment for better understanding. Here the Problem is the first line.
If more lines in the cell have the same problem, then you get 1 extra line for each, i.e. in the second picture 3 extra lines.
19012 19013
- activated Word Wrap
- activated Auto-fit
- no blank spaces after the last "l"
- Calibri 11
- Column width 10,86
If i adjust the columns width then the Auto-fit works properly.
But if you have enough rows you will never get a columns width that fits for all rows.
I searched many times in the web and this forum, but can only find people complaining without solution.
Can i solve the problem with a macro or a basic excel configuration?
thank you for your help
is there a way to get rid of the extra row height when the first line in the cell is full and Word Wrap activated?
See the Screenshot in the Attachment for better understanding. Here the Problem is the first line.
If more lines in the cell have the same problem, then you get 1 extra line for each, i.e. in the second picture 3 extra lines.
19012 19013
- activated Word Wrap
- activated Auto-fit
- no blank spaces after the last "l"
- Calibri 11
- Column width 10,86
If i adjust the columns width then the Auto-fit works properly.
But if you have enough rows you will never get a columns width that fits for all rows.
I searched many times in the web and this forum, but can only find people complaining without solution.
Can i solve the problem with a macro or a basic excel configuration?
thank you for your help