| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete a drop down box
How do I detee a drop down box once it has been created
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete a drop down box
If it is a dropdown from Data ValidationList just click on it and Data
ValidationClear All. If a dropdown from the Control Toolbox go into Design Mode and delete it. If from the Forms Toolbar just right-click and delete it. Gord Dibben MS Excel MVP On Tue, 21 Aug 2007 11:48:02 -0700, Nancy wrote: How do I detee a drop down box once it has been created |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete a drop down box
Hi,
Do the following: 1. Select the range with the dropdown list in the worksheet. 2. On the Data menu, click Validation. 3. Under validation Criteria, click "Any Value" from the "Allow" list. Note: If the "Allow" list displays "List" and your Source" text box displays the selected range, then change the selection in the Allow list to "Any Value" 4. Click Ok. Challa Prabhu "Nancy" wrote: How do I detee a drop down box once it has been created |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i delete drop box | Excel Discussion (Misc queries) | |||
| Delete key not enabled on macros drop down list | Excel Discussion (Misc queries) | |||
| delete used records from drop down list? | Excel Worksheet Functions | |||
| How do I delete a drop list button | Excel Worksheet Functions | |||
| How to add and delete items from a list box or drop down box? | Excel Discussion (Misc queries) | |||
Hybrid Mode
