Formatting text within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Try Alt-Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks to all ... exactly what I need!

Ron Coderre said:
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 said:
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.
Click to expand...
Click to expand...
 
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 :-)
------------------------------­------------------------------­----------------
 
Understood. Thanks for the input.

Ken Wright said:
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 :-)
------------------------------­------------------------------­----------------
Click to expand...
 
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 said:
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


:

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


:

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.
Click to expand...
Click to expand...
Click to expand...
 
Actually, yes
Thanks

Ron said:
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


:

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


:



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