Mulitple text lines in a single cell

M

Mrs.Aguire

I need to type several sentences into one single cell but I can not for the
life of me figure out how to get it to make mulitple text lines in one
cell...

It looks like this........

and I need
it to look
like this.

Please please help!
 
S

Sheeloo

After typing each line press ALT-ENTER instead of ENTER to go to the next
line in the same cell.
 
D

Dave

Hi,
Right click on the cell you want, then choose Format cells. Choose the
Alignment tab, then tick the Wrap text tick box.
This will give you multiple lines in your cell, but you won't have much
control over where each line starts and finishes. To control this, when you
type some text, then want to start a new line within the same cell, press
Alt+Enter.
Hope this helps.
Regards - Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top