How to remove a drop-down box in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
If not DV dropdowns as Kevin B suggests, maybe these are Autofilter buttons.

Data>Filter. Does Autofilter have a checkmark?

If so, click to uncheck.


Gord Dibben MS Excel MVP
 
Back
Top