Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I create a Drop Down List in a cell?

I've messed around with right click and "Create List" but just can'
seem to get it right.

I have a column labled "instrument" at the top. In that column, I'
like a drop down list for every row. The drop down list contains
items:


Euro
GBP
JPY
CHF

How do I go about making this list as it's just not happening for me a
the moment?

Thank

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default How do I create a Drop Down List in a cell?

Hi
see: http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


I've messed around with right click and "Create List" but just can't
seem to get it right.

I have a column labled "instrument" at the top. In that column, I'd
like a drop down list for every row. The drop down list contains 4
items:


Euro
GBP
JPY
CHF

How do I go about making this list as it's just not happening for me
at the moment?

Thanks


---
Message posted from http://www.ExcelForum.com/

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
Hello how do i create a drop down list in a cell? Priya Excel Discussion (Misc queries) 2 April 17th 09 01:19 PM
Create a drop-down list from a range of cell Olivia Excel Worksheet Functions 4 August 5th 08 11:09 PM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
how to create a drop down list without a pre-formed range of cell. Ahmad Excel Discussion (Misc queries) 2 October 27th 06 10:11 PM
Can I create a drop-down list that will reference other drop-down fdebelo Excel Worksheet Functions 3 January 7th 06 09:34 AM


All times are GMT +1. The time now is 07:54 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"