Excel Options - Wrap Text OFF!

  • Thread starter Thread starter Tim
  • Start date Start date
T

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!!!
 
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
 
Back
Top