Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) |