how do i enable multiple entries in the same cell under a label?
 

suppose i am making a spreadsheet showing me a people's details. and a person
has more than one hobbies and i want to diplay them in the single cell
corresponding to hobbies column header, how do i go about it?

how do i enable multiple entries in the same cell under a label?
 

separate them with a comma? or a newline, i.e. ht Alt-Enter after each hobby

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"triptianil" wrote in message
...
suppose i am making a spreadsheet showing me a people's details. and a
person
has more than one hobbies and i want to diplay them in the single cell
corresponding to hobbies column header, how do i go about it?

how do i enable multiple entries in the same cell under a label?
 

Bob has shown you a couple of methods, but do you really want to do this?

If you want to sort or filter later on you will have trouble with all data in
one cell.

Suggest you enter each piece of personal data in a separate cell.


Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 21:44:01 -0700, triptianil
wrote:

suppose i am making a spreadsheet showing me a people's details. and a person
has more than one hobbies and i want to diplay them in the single cell
corresponding to hobbies column header, how do i go about it?