| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge and Wrapping Text
Thank you so much!
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Merge and Wrapping Text
No problem. Happy to help!
"Té" wrote: Thank you so much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrapping Text | Excel Discussion (Misc queries) | |||
| text wrapping when text is pasted in excel | Excel Discussion (Misc queries) | |||
| wrapping text in merge cell limit | Excel Discussion (Misc queries) | |||
| I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
| Wrapping Text | Excel Discussion (Misc queries) | |||
Linear Mode
