Text Box in Excel
 

I have a workbook that contains data for about 800 store locations. When my
users select their store number their data is displayed. I want to have my
users be able to type a call to actions on one of the sheets inside the
workbook. But I can't find a good method for them to use. If I merge several
cells and give them room to type, they do well until they hit the enter key.
By hitting the enter key it takes them out of the merged cell. I want them to
be able to hit enter then take them to a different line within the same
merged cell. Any Thoughts
--
Kdon

Text Box in Excel
 

Hi

Use Alt+Enter to force a line feed within the cell.

--
Regards
Roger Govier

"KDon" wrote in message
...
I have a workbook that contains data for about 800 store locations. When
my
users select their store number their data is displayed. I want to have my
users be able to type a call to actions on one of the sheets inside the
workbook. But I can't find a good method for them to use. If I merge
several
cells and give them room to type, they do well until they hit the enter
key.
By hitting the enter key it takes them out of the merged cell. I want them
to
be able to hit enter then take them to a different line within the same
merged cell. Any Thoughts
--
Kdon