Help! How do you put a New Paragraph in Excel

[japorms]

Hi Guys,

Does anyone know how to add a new paragraph in a cell?

Example: Book Sale

It needs to look like this:

Book
Sale

Also, how to reverse it also. Thanks!

I can't find it in Help.

[Pete_UK]

Use Alt-Enter where you want to split the text.

To reverse it, either delete the character from that position, or do
Format | Cells | Alignment and uncheck Wrap text.

Hope this helps.

Pete

japorms wrote:
> Hi Guys,
>
> Does anyone know how to add a new paragraph in a cell?
>
> Example: Book Sale
>
> It needs to look like this:
>
> Book
> Sale
>
> Also, how to reverse it also. Thanks!
>
> I can't find it in Help.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=572350

[Sandy Mann]

jamorms,

Select the place where you want the text to break - in this case just to the
left of the "S" - and then press and hold Alt while you press Enter. To
remove it again sit in the place of the (invisible) line break character 10
and press delete. If the column is too narrow you will also have to select
Format > Cell > Alignment > Wrap Text

--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"japorms" <japorms.2cnbks_1155753606.6393@excelforum-nospam.com> wrote in
message news:japorms.2cnbks_1155753606.6393@excelforum-nospam.com...
>
> Hi Guys,
>
> Does anyone know how to add a new paragraph in a cell?
>
> Example: Book Sale
>
> It needs to look like this:
>
> Book
> Sale
>
> Also, how to reverse it also. Thanks!
>
> I can't find it in Help.
>
>
> --
> japorms
> ------------------------------------------------------------------------
> japorms's Profile:
> http://www.excelforum.com/member.php...fo&userid=6544
> View this thread: http://www.excelforum.com/showthread...hreadid=572350
>

[japorms]

thanks guys,

appreciate it.