09-19-2006, 11:08 AM
|
 |
"Eagle Eyed" Forum Moderator
|
|
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,102
|
|
Quote:
|
Originally Posted by harvindersingh1
Suppose from the cell range C10 to C30 I have to answer in yes and no. For that I want that whenever I shift to various cells mentioned in the cell range. A drop down list is formed showing the choice to be entered in yes or no.
|
Hi harvindersingh1,
Select your range C10:C30, then go to Data> Validation select the Settings tab, in the Allow select List, then in Source type
Yes,No
without any spaces, then OK
now when you select one of these cells the drop down appears, with Yes or No
oldchippy 
|