ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Lines of Text in One Cell (https://www.excelbanter.com/excel-discussion-misc-queries/199288-multiple-lines-text-one-cell.html)

tygaines

Multiple Lines of Text in One Cell
 
I am trying to achieve multiple lines of text in a single cell. I want the
right edge of the cell block to stop the text and kick it down to a new line
of text, but still within the same cell. Is this possible?

T. Valko

Multiple Lines of Text in One Cell
 
Format the cell to wrap text...

Select the cell in question
Goto the menu FormatCellsAlignment tabWrap textOK

The number of lines in the cell depends on how wide the column is and how
much text the cell contains.

--
Biff
Microsoft Excel MVP


"tygaines" wrote in message
...
I am trying to achieve multiple lines of text in a single cell. I want the
right edge of the cell block to stop the text and kick it down to a new
line
of text, but still within the same cell. Is this possible?





All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com