Thread: drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bobt Bobt is offline
external usenet poster
 
Posts: 84
Default drop down list

What you have is "Autofilter" turned on. To remove it, simply be in any cell
of a column with the drop down lists; from the DATA menu, choose FILTER then
AUTOFILTER. This will remove the filter and drop downs for you.

Bob Tulk
MOUS (XP/97)

"SFC Chris Lemley" wrote:

I have inherited a speedsheet where the whole first row, every column has a
drop down list. Even if i add a try to inserta column it has a drop down list
automatically in the first row. I want to either edit it and get rid of it,
or be able to insert a column without the dropdown. Any thoughts?