Lists in a cell

B

Bob McCloskey

I need to put a list of names in a cell. It is cumbersome to use spaces to
get to the next line. Is there a way that I can hit enter(or some other
function) to move to a next line within the same cell.

Thanks
Bob
 
B

Bill Ridgeway

To make a break within a cell press <Alt> and <Enter>

Regards.

Bill Ridgeway
Computer Solutions
 
K

Ken Wright

As per Bill's answer, however, a list in this format is generally indicative
of bad spreadsheet design, as entries should really have their own cells.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top