Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using Excel 98 and want to know how to get 2 lines of text in 1 cell
rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks |
#2
![]() |
|||
|
|||
![]()
Type part, then Alt-Enter, then the rest.
-- HTH Bob Phillips "!!!help!!!" wrote in message ... I am using Excel 98 and want to know how to get 2 lines of text in 1 cell rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks |
#3
![]() |
|||
|
|||
![]()
Use Alt+Enter to insert a "paragraph return" within a cell.
************ Anne Troy www.OfficeArticles.com "!!!help!!!" wrote in message ... I am using Excel 98 and want to know how to get 2 lines of text in 1 cell rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks |
#4
![]() |
|||
|
|||
![]()
Try ALT+ENTER when you want a carriage return.
Eric "!!!help!!!" wrote: I am using Excel 98 and want to know how to get 2 lines of text in 1 cell rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks |
#5
![]() |
|||
|
|||
![]()
I will give it a shot.
Format cell number text Format cell Alignment wrap text Two things will happen, the entire row will go to two lines high and the text may fill from the bottom or the top. If you want it to fill the other way then Format Cell Alignment Vertical Top|Bottom|Center. Hope it helps. "!!!help!!!" wrote in message ... I am using Excel 98 and want to know how to get 2 lines of text in 1 cell rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks |
#6
![]() |
|||
|
|||
![]()
And if you ever want to create a formula that does this:
=a1&char(10)&a2 (but make sure format|cells|alignment tab|wrap text is checked) !!!help!!! wrote: I am using Excel 98 and want to know how to get 2 lines of text in 1 cell rather than space it out over 2 cells. See below for example if you dont get it..... This is what (cell no.1) I mean. (cell no. 2) I want to be (cell no.1) able to do this. (cell no.1) Please help.....thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text lines in a cell | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |