Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple lines of text in a cell
How do you enter multiple lines of text in an Excel cell? (eg "for year of")
so that "for", "year" and "of" are on seperatle lines within the one cell? I have always used wrap text and then just kept hitting the space bar between the words in such a way that I achieved this. It was always a problem if I had to adjust the column width afterwards, then I had to go back to the cell and adjust the spaces between the words again. I saw a spreadsheet the other day that had these very words in a cell in such a way that the spacebar was not used. When you highlight the cell, you can see in the edit line that "for", "year" and "of" are stacked one on top of each other. I can't tell from "format cells" how this was done. All that seems to be checked off is "wrap text". Anyone got the answer to this? Thanks, Ken McI |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to split wrapped text in a single cell into multiple lines | Excel Discussion (Misc queries) | |||
putting multiple lines of text in one cell | Excel Discussion (Misc queries) | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) |