View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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.