View Single Post
  #2   Report Post  
Andy B
 
Posts: n/a
Default

Hi

Have a look at Data|Validation. This allows you to point at a list and have
the user select from it. Have a look here for some more info:
http://www.contextures.com/xlDataVal01.html

Andy


"CELL DROP DOWN MENU" <CELL DROP DOWN wrote
in message ...
In Excel, I want to set up a drop down arrow for a cell, in order to
select
from a choice of say 5 items which would be listed. The chosen item can
then
be clicked on for entry in the cell.