software

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
quot;Enterquot; 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-Proquot;AV Guyquot; wrote:

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

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

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

--

Dave Peterson

Try Alt-Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;AV Guyquot; gt; wrote in message
...
gt; I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt; title with several bulleted subpoints indented and under it. Every time I
hit
gt; quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt; appreciated.
Thanks to all ... exactly what I need!

quot;Ron Coderrequot; wrote:

gt; When editing a cell, if you hold down the [Alt] key when you press [Enter],
gt; that will put the subsequent text on a new line in the same cell.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;AV Guyquot; wrote:
gt;
gt; gt; I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt; gt; title with several bulleted subpoints indented and under it. Every time I hit
gt; gt; quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt; gt; appreciated.

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 :-)
------------------------------*------------------------------*----------------

quot;AV Guyquot; gt; wrote in message
...
gt; I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt; title with several bulleted subpoints indented and under it. Every time I
gt; hit
gt; quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt; appreciated.
Understood. Thanks for the input.

quot;Ken Wrightquot; wrote:

gt; Everyone has told you how to do it, but no-one has mentioned that maybe you
gt; shouldn't. It all depends on your data and what you are trying to achieve,
gt; but generally, you are better off having each element of a list in its own
gt; cell. If you are effectively just using Excel as a word processor then I
gt; guess it probably won't matter, but just worth mentioning.
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------Â*------------------------------Â*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------Â*------------------------------Â*----------------
gt;
gt;
gt;
gt;
gt; quot;AV Guyquot; gt; wrote in message
gt; ...
gt; gt; I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt; gt; title with several bulleted subpoints indented and under it. Every time I
gt; gt; hit
gt; gt; quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt; gt; appreciated.
gt;
gt;
gt;

Related question. In a large single cell used for text is it possible to
link to another singel cell. For example. quot;The sales for April were
lt;lt;put cell reference heregt;gt; which is an increase.quot;
thanks

Ron Coderre wrote:
gt; When editing a cell, if you hold down the [Alt] key when you press [Enter],
gt; that will put the subsequent text on a new line in the same cell.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;AV Guyquot; wrote:
gt;
gt;
gt;gt;I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt;gt;title with several bulleted subpoints indented and under it. Every time I hit
gt;gt;quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt;gt;appreciated.

Yes....here's one way:

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

Does that help?

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

XL2002, WinXP-Proquot;noybquot; wrote:

gt; Related question. In a large single cell used for text is it possible to
gt; link to another singel cell. For example. quot;The sales for April were
gt; lt;lt;put cell reference heregt;gt; which is an increase.quot;
gt; thanks
gt;
gt; Ron Coderre wrote:
gt; gt; When editing a cell, if you hold down the [Alt] key when you press [Enter],
gt; gt; that will put the subsequent text on a new line in the same cell.
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;AV Guyquot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt; gt;gt;title with several bulleted subpoints indented and under it. Every time I hit
gt; gt;gt;quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt; gt;gt;appreciated.
gt;

Actually, yes
Thanks

Ron Coderre wrote:
gt; Yes....here's one way:
gt;
gt; A1: = quot;The sales for April were quot;amp;TEXT(D1,quot;$#,###quot;)amp;quot; which is an increase.quot;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;noybquot; wrote:
gt;
gt;
gt;gt;Related question. In a large single cell used for text is it possible to
gt;gt;link to another singel cell. For example. quot;The sales for April were
gt;gt;lt;lt;put cell reference heregt;gt; which is an increase.quot;
gt;gt;thanks
gt;gt;
gt;gt;Ron Coderre wrote:
gt;gt;
gt;gt;gt;When editing a cell, if you hold down the [Alt] key when you press [Enter],
gt;gt;gt;that will put the subsequent text on a new line in the same cell.
gt;gt;gt;
gt;gt;gt;Does that help?
gt;gt;gt;
gt;gt;gt;***********
gt;gt;gt;Regards,
gt;gt;gt;Ron
gt;gt;gt;
gt;gt;gt;XL2002, WinXP-Pro
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;quot;AV Guyquot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;I'm pretty new to Excel ... I want to emulate my formatting in Word of a
gt;gt;gt;gt;title with several bulleted subpoints indented and under it. Every time I hit
gt;gt;gt;gt;quot;Enterquot; for a new line, I get skipped to a new cell. Any help will be
gt;gt;gt;gt;appreciated.
gt;gt;