ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple lines of text within one cell (https://www.excelbanter.com/excel-discussion-misc-queries/210427-multiple-lines-text-within-one-cell.html)

pluaggie

Multiple lines of text within one cell
 
I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text.

For example, I want a cell to look like this:
1. text text
2. text text
3. text text

I know it can be done because I received a file that already had this.
Unfortunately, I can't figure out how it was done.

Mike

Multiple lines of text within one cell
 
Alt+Enter Should do it

"pluaggie" wrote:

I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text.

For example, I want a cell to look like this:
1. text text
2. text text
3. text text

I know it can be done because I received a file that already had this.
Unfortunately, I can't figure out how it was done.


MikeJohnB

Multiple lines of text within one cell
 
Type your first line of text

Press Lefthand Alt and Enter together

Type Your second line of text

Press Lefthand Alt and Enter togther

You get the picture???????

Regards Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"pluaggie" wrote:

I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text.

For example, I want a cell to look like this:
1. text text
2. text text
3. text text

I know it can be done because I received a file that already had this.
Unfortunately, I can't figure out how it was done.


pluaggie

Multiple lines of text within one cell
 

Thanks Mike. I felt like an idiot, but I had to ask.

"Mike" wrote:

Alt+Enter Should do it

"pluaggie" wrote:

I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text.

For example, I want a cell to look like this:
1. text text
2. text text
3. text text

I know it can be done because I received a file that already had this.
Unfortunately, I can't figure out how it was done.


Mike

Multiple lines of text within one cell
 
No problem. Your welcome.

"pluaggie" wrote:


Thanks Mike. I felt like an idiot, but I had to ask.

"Mike" wrote:

Alt+Enter Should do it

"pluaggie" wrote:

I want to have multiple lines of text within one cell. I am not referring to
text wrapping. I want to press enter and go to another line of text.

For example, I want a cell to look like this:
1. text text
2. text text
3. text text

I know it can be done because I received a file that already had this.
Unfortunately, I can't figure out how it was done.



All times are GMT +1. The time now is 10:08 PM.

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