Home › Forums › Tech › Windows › New Line Character in Excel Custom Format › Re: New Line Character in Excel Custom Format
2012-09-13 at 14:23
#2375
Mr. Mangus
Participant
On http://www.excelbanter.com I found a very clever suggestion on how to solve the column width problem.
– Select the cells in question
– Uncheck Wrap text
– Check Shrink to fit
– Check Wrap text once again
This allows you to narrow the column to a perfect width
Problem remains for Auto-Resizing rows:
if you try to Auto-resize rows, your second line of your formatting will be hidden.
Any suggestion how to fix that?