Excel Options - Wrap Text OFF!

[Tim]

Can anyone tell me how I can have the default setting in
Excel set to NOT wrap the text?
I do a lot of copy/pasting and it drives me nuts to keep
having to deselect the wrap text.

HELP!!!

 

[Dave Peterson]

For me, the default is off.

But I think excel tries to help. If you paste text into a cell and that text
contains alt-enter, then excel says: you need wraptext on! And does it.

You could give up trying to do it after each paste and just do one mighty change
(all your cells selected) when you're finished.

or you could use a macro and assign it to your favorite shortcut key:

Option Explicit
Sub togglewraptext()
With Selection
.WrapText = Not .Cells(1).WrapText
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm