View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default How can i have a drop-down menue in a cell of an Excel preadsheet

Click in the cell(s) where the drop-down should appear and select Data
Validation. You'll probably select a 'List' and either type the values
(separated by commas) or indicate a range of cells where each cell contains
one valid selection.
You'll also have options to select what action to take if an invalid value
is entered (stop, show a warning, ...)

"Reza Rassoulli" wrote:

I am trying to have a choice of different options in some cells of a
spreadsheet and need to know how to creat them.

appreciate your help.

Reza