Cannot remove drop-down list from top row

  • Thread starter Thread starter Kenny Kepler
  • Start date Start date
K

Kenny Kepler

Hi,

I have inherrited an Excel spreadsheet and my office package has recently
been upgraded to Office 2003. For some reason, even after I turn off the
auto-filters certain columns retain their drop-down boxes and I can't get
rid of them. When I click on the drop downs nothing happens, so they don't
work or seem to do anything. It is only a cosmetic problem but it is
driving me nuts!! Please can someone help me with this. I can't find an
answer anywhere.

TIA
Kenny
 
Just something to try...

Try selecting a different range and applying data|filter|autofilter there.

Maybe you'll see the arrows there and the others will disappear.
 
Back
Top