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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple If Statements in the same cell 2
want to track time while paste value in multiple column of same roe 1
looking up multiple values in an arrray 5
Multiple data entry with multiple results 2
Excel 2 into 1 6
What formula do I use to show the last cell with text in a colum 3
How do I get Rid of the Circumflex Accent (Caret) 2
Print same form with different, listed data 4

Back
Top