ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merge and Wrapping Text (https://www.excelbanter.com/excel-discussion-misc-queries/191035-merge-wrapping-text.html)


Merge and Wrapping Text
 
In Excel 2007 I have a premade worksheet, and in cell a1 they have merged it
from a1 to g1. Somehow they've created it were it looks like

Benjamin of Brussels International
International Chocolate Distributors, Inc.

They've somehow wrapped the text. In the formula bar Benjamin of Brussels
International is on one line and then International Chocolate Distributors is
on another line. When I enter text and then I press enter to drop down to
the next line it automatically jumps to the next cell. How can I enter two
lines of information into one cell without constantly pressing the spacebar?
Please help!!!


Sean Timmons

Merge and Wrapping Text
 
Type your first line, then hold down Alt+Enter. This will enter a line break
for you.

"Té" wrote:

In Excel 2007 I have a premade worksheet, and in cell a1 they have merged it
from a1 to g1. Somehow they've created it were it looks like

Benjamin of Brussels International
International Chocolate Distributors, Inc.

They've somehow wrapped the text. In the formula bar Benjamin of Brussels
International is on one line and then International Chocolate Distributors is
on another line. When I enter text and then I press enter to drop down to
the next line it automatically jumps to the next cell. How can I enter two
lines of information into one cell without constantly pressing the spacebar?
Please help!!!



Merge and Wrapping Text
 
Thank you so much!

Sean Timmons

Merge and Wrapping Text
 
No problem. Happy to help!

"Té" wrote:

Thank you so much!



All times are GMT +1. The time now is 05:50 AM.

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