wrap around text in Excel cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leslie James - 23 Sep 2007 05:29 GMT

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.

Reply to this Message

CyberTaz - 23 Sep 2007 06:40 GMT

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

On 9/23/07 12:29 AM, in article
1190521769.304434.52740@o80g2000hse.googlegroups.com, "Leslie James"
<jmsatown@rcn.com> wrote:

> 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
[quoted text clipped - 4 lines]
> cell area.
> Thanks for help.

Reply to this Message

JE McGimpsey - 23 Sep 2007 14:02 GMT

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

Reply to this Message

CyberTaz - 23 Sep 2007 14:40 GMT

<snip>

> 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

Reply to this Message

Mac Forum / Applications / Excel / September 2007

wrap around text in Excel cells