Home Forums Tech Windows New Line Character in Excel Custom Format Re: New Line Character in Excel Custom Format

#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?