Drop downs in Excel??

Latest Articles

Drop downs in Excel??

Downsizer Forum Index -> IT Matters

Author

Message

tahir

Joined: 28 Oct 2004
Posts: 45669
Location: Essex

Posted: Tue Jan 09, 07 2:02 pm Post subject: Drop downs in Excel??
A I dreaming or is this possible? What I want is a cell with a drop down that contains values like: 1: 1st Sample 2: 2nd Sample 3: Fit 4: Approval 5: Production 6: Salesman

Northern_Lad

Joined: 13 Dec 2004
Posts: 14210
Location: Somewhere

Posted: Tue Jan 09, 07 2:06 pm Post subject:
It's possible, but I've never done it on the sheet itself; I use forms.

BahamaMama

Joined: 21 Sep 2006
Posts: 2315
Location: Away with the fairies

Posted: Tue Jan 09, 07 2:08 pm Post subject:
I am not an expert but does the 'add note' function give you what you want?

tahir

Joined: 28 Oct 2004
Posts: 45669
Location: Essex

Posted: Tue Jan 09, 07 2:23 pm Post subject:
Ta guys, done it with Forms

High Green Farm

Joined: 30 Nov 2004
Posts: 349
Location: Mid-Suffolk

Posted: Tue Jan 09, 07 10:03 pm Post subject:

tahir wrote:

Ta guys, done it with Forms

Can also do it with Data/Validation, which is easier if you want to use the cell results in a formula. Forms sit on top of the spreadsheet and don't automatically effect the contents of a cell.

Select the cell or range of cells you want it to appear in, and the select Data/Validation and under Allow select List. You can then type a list under Source, comma separated or alternatively link it to a range on your spreadsheet.

tahir

Joined: 28 Oct 2004
Posts: 45669
Location: Essex

Posted: Wed Jan 10, 07 10:34 am Post subject:
Funny enough ended up going from forms to Data Validation

	Downsizer Forum Index -> IT Matters	All times are GMT
Page 1 of 1

View Latest Posts