Drop down list

harvindersingh1 · #1 09-19-2006, 05:18 AM

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.

**oldchippy** · #2 09-19-2006, 11:08 AM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)