wrap around text in Excel cells

[Leslie James]

I'm finally making the switch from AppleWorks to Office:Mac. I'm
still having to work out little new details here and there, though I'm
liking the switch. I'd like to know how to make text "wrap
around" (as this was called in AppleWorks) within a spreadsheet cell,
so that it essentially returns and makes multiple lines of text within
one cell instead of just shooting out straight into the neighboring
cell area.
Thanks for help.

 

[CyberTaz]

As answered in the Word group

Hi Leslie -

Go to Format> Cells - Alignment, tick the box for Wrap Text.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Go to Format> Cells - Alignment, tick the box for Wrap Text.

Alternatively, check the Wrap Text checkbox in the Alignment pane of the
Formatting Palette.

And, just for Bob, you can enter this in the Immediate Window of the
Visual Basic Editor:

[a1].wraptext = true

but almost nobody would do that...<g>

 

[CyberTaz]

And, just for Bob, you can enter this in the Immediate Window of the
Visual Basic Editor:

[a1].wraptext = true

but almost nobody would do that...<g>

<snip>

Thanks John -

I just don't understand *how* I could have overlooked that option;-}

Regards |:>)
Bob Jones
[MVP] Office:Mac