PC Review


Reply
Thread Tools Rate Thread

How can i have a drop-down menue in a cell of an Excel preadsheet

 
 
=?Utf-8?B?UmV6YSBSYXNzb3VsbGk=?=
Guest
Posts: n/a
 
      6th Jul 2006
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
 
Reply With Quote
 
 
 
 
Maistrye
Guest
Posts: n/a
 
      6th Jul 2006

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

 
Reply With Quote
 
=?Utf-8?B?YnBlbHR6ZXI=?=
Guest
Posts: n/a
 
      6th Jul 2006
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

 
Reply With Quote
 
Ragdyer
Guest
Posts: n/a
 
      6th Jul 2006
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
vb drop down menue conorot Microsoft Excel Misc 1 17th May 2006 10:03 AM
How do I insert a check / uncheck box in an excel preadsheet? =?Utf-8?B?TmF2eSBDaGllZg==?= Microsoft Word Document Management 1 2nd Oct 2005 11:36 PM
Drop-Down-Menue Harald Staff Microsoft Excel Discussion 3 4th May 2005 11:40 AM
Re: DROP DOWN MENUE Debra Dalgleish Microsoft Excel Misc 1 4th Feb 2004 03:50 AM
Re: DROP DOWN MENUE Peo Sjoblom Microsoft Excel Misc 0 3rd Feb 2004 06:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:16 PM.