View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Rayashe Rayashe is offline
external usenet poster
 
Posts: 22
Default Does Excel Support Drop-Down Menus to Select Information?

You can use the 'Data Validation' menu command:
First you would need to create your list somewhere out of the way of your
work area eg cell AA2 has HOUSE, cell AA3 has FLAT, cell AA4 has COTTAGE,
cell AA5 has GARAGE, etc
Now highlight the column or range of cells in a column that you want the
drop-down list to be used in.
Then use the Data Validation menu command and in SettingsAllow choose List
and this opens up Source - enter your list range here eg AA2:AA5
Click on OK and that should do it for you.

"T. Hulot" wrote:

This is exactly what I want, but is there a way to make this a default
setting for an entire column? Or will I have to right-click and
select this for each and every cell in the column?

In a column, right-click and "Pick from drop down list" may help/