View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default How to TURN OFF "wrap text" for all new workbooks/sheets

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.

"MK" wrote:

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?