![]() |
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!!! |
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!
|
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