0

Hi there,

I'm currently working on a spreadsheet in Microsoft Excel 2007, and need to enter a few paragraphs of text within a group of merged cells.

I would like to have seperate lines of text (as I have just started a new paragraph within this post) but when I press "enter" it simply takes me to the cell below.

Does anyone know how you can overcome this? I know you are able to do this as i've done it before somehow!

2
Contributors
2
Replies
5
Views
9 Years
Discussion Span
Last Post by hailes_uk
0

Go into Format/Cells/Alignment and check Wrap Text.

To force a new line, use Alt+Enter.

Another way is to create a text box in Word, and then paste it as an object in Excel.

0

Hi MidiMagic,

This worked! Thank you so much, it was really bugging me!

Hailes

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.