| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down option in a cell
hello!
How do you remove a drop down box within a cell? I tried Data/Validation/Clear All, but it did not remove the box. Any suggestions? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down option in a cell
Maybe it isn't a DV drop-down.
There are other forms of drop-downs from the Control Toolbox or the Forms Toolbars. Could be a list box, combobox or somesuch creature. F5SpecialObjectsOK Anything selected? Gord Dibben Excel MVP On Thu, 17 Nov 2005 13:21:04 -0800, cdeldegan wrote: hello! How do you remove a drop down box within a cell? I tried Data/Validation/Clear All, but it did not remove the box. Any suggestions? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down option in a cell
Right click on the box, if you can edit it, you can delete it or cut
it, if not then you mat have an activeX. Bring up the control toolbar=select the button with the speed quare on it, this puts you in design mode, now when you put the mouse cursor over the box it should turn into a little + , if that happens then you can right click and delete(or cut) dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| How do I set up a drop down choice in a cell | Excel Discussion (Misc queries) | |||
| Is there any way to create a drop down calendar into a cell in ex. | Excel Discussion (Misc queries) | |||
| add option to drop down menu | Excel Discussion (Misc queries) | |||
Linear Mode
