Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions in a cell help | New Users to Excel | |||
Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) |