Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple functions in a cell help Mikjall777 New Users to Excel 5 August 11th 06 02:23 PM
Date and time stamping multiple cells for multiple entries. Gerald Excel Worksheet Functions 1 May 9th 06 01:45 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Counting Multiple Values In A Cell DiamondDean Excel Worksheet Functions 1 August 20th 05 07:22 AM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"