Link to home
Start Free TrialLog in
Avatar of arendt73

asked on

Define lines in specific Microsoft Excel 2010 column cells that will be used in mail merge

I want to create a cell column (column C will have house mailing addresses) with a defined width and height that allows up to four lines in a cell. Is it possible if a person hits enter in the specific cell, it does not jump to the next cell, but goes to the next line in the cell?

For example, I type 100 Anywhere Street and hit return. It takes me to the next line in the same cell where I would type Suite 12345. I hit return and it takes me to the next line and type in Baltimore, MD 21236.

After completing this process, I want to mail merge (column C) into Word. Is this possible using my desired request?

Any suggestions and recommendations is greatly appreciated. Thank you.
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Use Ctrl-Enter instead of only Enter
No, ssaqibh, it's Alt-Enter to create a line break in a cell.

Ctrl-Enter will enter the formula bar content into a selected range of cells.

cheers, teylyn
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oops....+1 to you teylyn