View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to install a drop down list excel 2002

Suppose your words list is in say: A10:A12

Select A1 (or select the range, say A1:A3)
Click Data Validation
Allow: List
Source: =$A$10:$A$12
Click OK.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Techno Grandma" wrote:
I have a table with a column I want to let the user choose from a list of
words to fill the cell. I have made a list of the words on my worksheet
below my table. How do I get the drop down list to happen in the column.
Thanks