ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Typing more than 1 line in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/191177-typing-more-than-1-line-cell.html)

Linda in IL

Typing more than 1 line in a cell
 
How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL

Jim Thomlinson

Typing more than 1 line in a cell
 
Hold down the Alt key and hit Enter
--
HTH...

Jim Thomlinson


"Linda in IL" wrote:

How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL


Linda in IL[_2_]

Typing more than 1 line in a cell
 
Thank you soooooo much Jim!!!

"Jim Thomlinson" wrote:

Hold down the Alt key and hit Enter
--
HTH...

Jim Thomlinson


"Linda in IL" wrote:

How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL


LeonIloilo

Typing more than 1 line in a cell
 
try with ALT + ENTER at the place you want.


"Linda in IL" <Linda in schreef in bericht
...
How do I do this? I have enlarged the cell and am using auto wrap. I want
to
type in the customers name and address on 3 lines. I can get it to wrap,
but
not where I want it to, ie. it will wrap at the end of the width of the
cell
but I want it to wrap at the end of the name.
TIA
Linda in IL




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

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