How to TURN OFF "wrap text" for all new workbooks/sheets

M

MK

I'm tired of always having to select all rows/columns, every time I start a
new workbook, and having to always TURN OFF text wrapping.

I tried to save that setting to the default sheet template, but I guess I
didn't do it right. Can someone tell me how to make NO WRAPPING the default?
 
B

BoniM

The default is text wrapping off. This makes me think that maybe it has
something to do with the way you're entering data into the sheet? If you
are, for example, pasting from an HTML document, it will turn word wrap on in
an attempt to match the original format.
If that's the problem, you can avoid this by using edit, paste special to
paste your selection as text only. This will, however, also get rid of any
other formatting.
 
D

Dave Peterson

It sounds like you have a book.xlt template file in your XLStart folder that has
the cells formatted to wrap text.

Open this book.xlt, change the format, and save it again.

Then click that New icon to get a new workbook and test it out.
 
M

MK

I think I was modifying SHEET, instead of BOOK -- or modifying the template
in the wrong folder, or something. I found the right book.xlt, fixed it,
saved it, and I'm good to go.

Thanks!
 
Top