Formatting text within a cell
 

I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AV Guy" wrote:

I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

You can use alt-enter to force a new line within a cell.

AV Guy wrote:

I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

--

Dave Peterson

Formatting text within a cell
 

Try Alt-Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"AV Guy" wrote in message
...
I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I
hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Thanks to all ... exactly what I need!

"Ron Coderre" wrote:

When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AV Guy" wrote:

I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Everyone has told you how to do it, but no-one has mentioned that maybe you
shouldn't. It all depends on your data and what you are trying to achieve,
but generally, you are better off having each element of a list in its own
cell. If you are effectively just using Excel as a word processor then I
guess it probably won't matter, but just worth mentioning.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"AV Guy" wrote in message
...
I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I
hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Understood. Thanks for the input.

"Ken Wright" wrote:

Everyone has told you how to do it, but no-one has mentioned that maybe you
shouldn't. It all depends on your data and what you are trying to achieve,
but generally, you are better off having each element of a list in its own
cell. If you are effectively just using Excel as a word processor then I
guess it probably won't matter, but just worth mentioning.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------




"AV Guy" wrote in message
...
I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I
hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Related question. In a large single cell used for text is it possible to
link to another singel cell. For example. "The sales for April were
<<put cell reference here which is an increase."
thanks

Ron Coderre wrote:
When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AV Guy" wrote:


I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Yes....here's one way:

A1: = "The sales for April were "&TEXT(D1,"$#,###")&" which is an increase."

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"noyb" wrote:

Related question. In a large single cell used for text is it possible to
link to another singel cell. For example. "The sales for April were
<<put cell reference here which is an increase."
thanks

Ron Coderre wrote:
When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AV Guy" wrote:


I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.

Formatting text within a cell
 

Actually, yes
Thanks

Ron Coderre wrote:
Yes....here's one way:

A1: = "The sales for April were "&TEXT(D1,"$#,###")&" which is an increase."

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"noyb" wrote:


Related question. In a large single cell used for text is it possible to
link to another singel cell. For example. "The sales for April were
<<put cell reference here which is an increase."
thanks

Ron Coderre wrote:

When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"AV Guy" wrote:



I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
appreciated.