ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   double lines (https://www.excelbanter.com/excel-discussion-misc-queries/16708-double-lines.html)

WFDFirefighter

double lines
 
I am trying to type and address in a cell and can't get it to drop down to
make another line, please help

CLR

Use Alt-Enter instead of just Enter.........

Vaya con Dios,
Chuck, CABGx3


"WFDFirefighter" wrote in message
...
I am trying to type and address in a cell and can't get it to drop down to
make another line, please help




CyberTaz

Hello-

Chuck's reply is valid for creating a line break in a cell, so no challenge
there.

Just a suggestion, though - it sounds like the data you are entering is
possibly going to be used for mailing label or some similar data operations.
If this is the case you might want to consider storing each data item in a
separate cell. If you store, eg., City+State+Zip all in one cell, you may run
into some serious limitations later on.

HTH |:)

"WFDFirefighter" wrote:

I am trying to type and address in a cell and can't get it to drop down to
make another line, please help



All times are GMT +1. The time now is 12:40 PM.

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