Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add A Line In A Text Cell
Greetings,
I need to add a line in a cell being used as a header. There are three ways to do this: 1) Use Char(10) in a formula - disadvantage is no formatting (Size, color or font) 2) Use a LOT of spaces - disadvantage is it looks messy and sometimes does unexpected things. 3) Use some keystroke combination to force a line feed - disadvantage is you cannot mix text and formulas (I can live with that).. I am looking for number 3. Anyone know what that keystroke combination is? Any help is appreciated, thanks. -Minitman |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add A Line In A Text Cell
You don't need a formula to insert the CHAR(10):
In a cell: helloALT-ENTERworld What I mean ( I confused even myself) is that after typing the o in hello, touch ALT-ENTER before typing world -- Gary''s Student - gsnu2007k "Minitman" wrote: Greetings, I need to add a line in a cell being used as a header. There are three ways to do this: 1) Use Char(10) in a formula - disadvantage is no formatting (Size, color or font) 2) Use a LOT of spaces - disadvantage is it looks messy and sometimes does unexpected things. 3) Use some keystroke combination to force a line feed - disadvantage is you cannot mix text and formulas (I can live with that).. I am looking for number 3. Anyone know what that keystroke combination is? Any help is appreciated, thanks. -Minitman |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add A Line In A Text Cell
Hey Gary's Student,
Thanks for the fast reply That is what I was looking for. Thanks. -Minitman On Wed, 19 Nov 2008 16:22:02 -0800, Gary''s Student wrote: You don't need a formula to insert the CHAR(10): In a cell: helloALT-ENTERworld What I mean ( I confused even myself) is that after typing the o in hello, touch ALT-ENTER before typing world |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep text at top line of cell | Excel Discussion (Misc queries) | |||
Why does text in a cell appear as a line of '#' symbols? | Excel Discussion (Misc queries) | |||
I have alot of text in a cell, I just want to see the top line | Excel Worksheet Functions | |||
Can you get line breaks in a text cell | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) |