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.
Microsoft ExcelSpreadsheetsMicrosoft Word

Avatar of undefined
Last Comment
Saqib Husain

8/22/2022 - Mon
Saqib Husain

Use Ctrl-Enter instead of only Enter
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Saqib Husain

Oops....+1 to you teylyn
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck