We won again!

Great victory for the People - Tax Cut!

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

#2375

Deprecated: Function seems_utf8 is deprecated since version 6.9.0! Use wp_is_valid_utf8() instead. in /var/www/DWCTEST/wp-includes/functions.php on line 6131

Deprecated: Function seems_utf8 is deprecated since version 6.9.0! Use wp_is_valid_utf8() instead. in /var/www/DWCTEST/wp-includes/functions.php on line 6131
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?