ALT + Enter and Wrap Text

  • Thread starter Thread starter Christopher
  • Start date Start date
C

Christopher

Thanks for the advice, even if it wasn't necessarily what I wanted t
hear ;-)

I can work around this limitation and still avoid the dreaded Merg
Cells (always the optimist here...).

Cheers
 
An ugly possibility--use a function:

="item 1" & char(10) & "item 2" & char(10) & "item 3"

A not so ugly possibility:

Add a macro to your personal.xls workbook that toggles the setting. Assign it a
shortcut key and when you're annoyed with xl, just use your shortcut key:

Option Explicit
Sub ToggleWrapText()
Selection.WrapText = Not ActiveCell.WrapText
End Sub

It toggles the setting to the opposite setting for the activecell in the
selection.
 
Back
Top