wrap around text in Excel cells

L

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.
 
C

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
 
J

JE McGimpsey

CyberTaz said:
Go to Format> Cells - Alignment, tick the box for Wrap Text.
Click to expand...

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>
 
C

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>
Click to expand...
<snip>

Thanks John -

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

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