I am trying to type within a cell, three seperate lines of text with a blank
line between them, obviously everytime I press return it takes you on to the
next cell, is there any way I can do it.
to look a bit like this:

Excel Query

for

Ruth Gadsbey

but it all needs to be centred too, acrossed merged cells
Hope you can help

Try Alt-Enter for new line

"Ruth" wrote:

I am trying to type within a cell, three seperate lines of text with a blank
line between them, obviously everytime I press return it takes you on to the
next cell, is there any way I can do it.
to look a bit like this:

Excel Query

for

Ruth Gadsbey

but it all needs to be centred too, acrossed merged cells
Hope you can help

Thank you I must have tried every other combination and thought I had tried
that one, but obviously not 'cos it worked.
Thanks
Ruth

"Greg" wrote:

Try Alt-Enter for new line

"Ruth" wrote:

I am trying to type within a cell, three seperate lines of text with a blank
line between them, obviously everytime I press return it takes you on to the
next cell, is there any way I can do it.
to look a bit like this:

Excel Query

for

Ruth Gadsbey

but it all needs to be centred too, acrossed merged cells
Hope you can help