View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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!!!