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

Data -> Validation...

Change the "Allow" to "List", make sure the In-cell dropdown i
checked, and supply the list of values in the "Source" area. (Can be
typed list, a list somewhere in the spreadsheet, etc

--
Maistry
-----------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...fo&userid=3607
View this thread: http://www.excelforum.com/showthread.php?threadid=55906

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

Go to Debra Dalgleish's web site and scroll down to the D's.

Check out the pages on "Data Validation", for all you'll need to know about
this subject:

http://www.contextures.com/tiptech.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Reza Rassoulli" <Reza (E-Mail Removed)> wrote in message
news:6129ED3C-ABD7-423B-936B-(E-Mail Removed)...
>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