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

T

triptianil

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?
 
B

Bob Phillips

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)
 
G

Gord Dibben

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
 
Top