View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Adding drop-down list to spreadsheet

In the cell where the selection is to be made, use Data Validation. Select
List in the first drop-down then in the text box either type the allowed
values (separated by commas) or select a set of cells (from the same sheet)
containing those values.

"KDill" wrote:

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
--
Thank you,

KDill