Inserting a drop down list in an cell

  • Thread starter Thread starter kevvyb
  • Start date Start date
K

kevvyb

Can anybody give me some pointers as to how I do this. I know I need t
create the list somewhere on the spreadsheet but how do i insert th
function that gives the drop down arrow and the box to view the list i
the target cell
 
Have a look here and see if this is what you want
http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Create your list down a single column, somewhere out of sight.........then
left-click on the cell you want the Validation Box in, then Data >
Validation > Allow List > then click on the Source window arrow, and then
highlight your list, then click on the window arrow again, then > make sure
"In-cell dropdown box is checked, then > OK

Vaya con Dios,
Chuck, CABGx3
 
Back
Top