Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove a drop-down box in Excel?
I copied a portion of a form that was protected and needed to delete some of
the original information. I unprotected the form and deleted the necessary rows and columns. When I was done, there were 3 drop down boxes atop some of the columns. How do I eliminate them? I do not want them in or on the new form. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove a drop-down box in Excel?
Select the columns with the drop-down combo boxes and click the CLEAR ALL
command button to remove the data validation list from the selected range. -- Kevin Backmann "AngloAlly" wrote: I copied a portion of a form that was protected and needed to delete some of the original information. I unprotected the form and deleted the necessary rows and columns. When I was done, there were 3 drop down boxes atop some of the columns. How do I eliminate them? I do not want them in or on the new form. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove a drop-down box in Excel?
If not DV dropdowns as Kevin B suggests, maybe these are Autofilter buttons.
DataFilter. Does Autofilter have a checkmark? If so, click to uncheck. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 11:26:03 -0700, AngloAlly wrote: I copied a portion of a form that was protected and needed to delete some of the original information. I unprotected the form and deleted the necessary rows and columns. When I was done, there were 3 drop down boxes atop some of the columns. How do I eliminate them? I do not want them in or on the new form. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How would I remove a drop down menu from an excel template? | Excel Discussion (Misc queries) | |||
remove a drop-down list in excel | Excel Worksheet Functions | |||
Excel - How do I remove a drop down box? | Excel Worksheet Functions | |||
Remove drop-down list in Excel | Excel Discussion (Misc queries) | |||
remove a drop-down list | Excel Worksheet Functions |