Thank you. I got that part. I want to format all cells to automatically give
me a line return when I hit enter, not move to another cell. I want it to do
what it does in a table in Word.

"Bernard Liengme" wrote:

You can insert a line return by holding down ALT while pressing ENTER (this
is called 'text wrap')
Sometimes you then nee to format the cell to permit text wrap
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Sue S" <Sue wrote in message
...