drop down lists

  • Thread starter Thread starter Alex McKenzie
  • Start date Start date
A

Alex McKenzie

Hi all

Was wondering if somebody could give me some
clues on how to insert a drop down
list into a cell (if this can be done)

This list will contain the names of a numer of' stocks
of which I need to select and display one

Many thanks

Alex
 
Hi!

Depending on how many items you want to have in the drop down:

If the list will be realatively long.........

In an out of the way location on your sheet enter the items in a range, say,
AA1:AA50

Give this range a defined name:

Goto Insert>Name>Define
Name: StoclkList (or whatever)
Refers to: =Sheet1!$AA$1:$AA$50
OK

Select the cell where you want the drop down

Goto Data>Validation
Allow: List
Source: =StockList
Ok

If you only have a few items for the list then you can leave out the named
range stuff and in the Source for the list just type in the items separated
by a comma:

Stock1,Stock2,Stock3,Stock4

Biff
 
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

Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
Drop Down Lists 2007 10
customize drop-down box 1
data validation fonts differ in drop down box 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down with dynamic named range offsheet source list 14
Drop down lists 6

Back
Top