Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put several words one on top the other in one cell?
I guess, in other words what I'm looking for is if I wanted to write a
paragraph and place that entire paragraph in one cell. But, I want to be able to see the entire paragraph in that one cell even after I place information in the cell to the right of it. I do know how to size the individual cell to accommodate the size of paragraph I want. Its got to be easy but I just havent figured out where to click. €“ Thanks for your kind help €“ mark1000000 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put several words one on top the other in one cell?
try out insert coment, right click on the cell and select, insert comment, you can adjust the size of the comment box accordingly, if that won't work for you you could always use a textbox, in the drawings toolbar select textbox, you can place the textbox wherever you require, to add extra lines to a cell, hit Alt-Enter, this will give you another line in the cell, -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=574433 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put several words one on top the other in one cell?
either use the cell format format...cell...alignment...wordwrap or use alt-enter to split the cell text into paragraphs hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=574433 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put several words one on top the other in one cell?
Type the text in the cell.
Then right-click - Format Cells - Alignment - Click on the "Wrap Text" box. That should work. "mark1000000" wrote: I guess, in other words what I'm looking for is if I wanted to write a paragraph and place that entire paragraph in one cell. But, I want to be able to see the entire paragraph in that one cell even after I place information in the cell to the right of it. I do know how to size the individual cell to accommodate the size of paragraph I want. Its got to be easy but I just havent figured out where to click. €“ Thanks for your kind help €“ mark1000000 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I put several words one on top the other in one cell?
The answer came back within 5 minutes.
James Hamilton and tony h had just what I was looking for I thank you very much for that. And thank you too davesexcel for your speedy response. I really can't believe how quick you came back with answers thanks a mill. Now dumb me found the answer before I came back here. I should have done this in the first place, but didn't. The reason I didn't is because I thought there would be to many entries. At any rate, here's want I did. When in Excel I pressed F1 for help, typed in "cell" enter. Went done the list of 30 results, clicked on "Wrap text in a cell". And there was the answer everyone gave me. I know kind of dumb that I didn't figure the simple process out before on how to find answers on my own. - Thanks everybody for your quick responses - mark1000000 "James Hamilton" wrote: Type the text in the cell. Then right-click - Format Cells - Alignment - Click on the "Wrap Text" box. That should work. "mark1000000" wrote: I guess, in other words what I'm looking for is if I wanted to write a paragraph and place that entire paragraph in one cell. But, I want to be able to see the entire paragraph in that one cell even after I place information in the cell to the right of it. I do know how to size the individual cell to accommodate the size of paragraph I want. Its got to be easy but I just havent figured out where to click. €“ Thanks for your kind help €“ mark1000000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
How Do? Take two words in cell 1 and slpit them to cell 2 & 3 | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |