Turning Off an Advanced Filter
 

I've activated Advanced Filter on a spreadsheet and now I cannot turn
it off. I want to switch to auto filter but this option is no longer
available. I see that someone else had this same problem back on 12
Feb 08 but no way to fix the problem was mentioned.

Someone please help!

Turning Off an Advanced Filter
 

DataFilterShow All

Doesn't that work?

--
Biff
Microsoft Excel MVP


"Leanne H" wrote in message
...

I've activated Advanced Filter on a spreadsheet and now I cannot turn
it off. I want to switch to auto filter but this option is no longer
available. I see that someone else had this same problem back on 12
Feb 08 but no way to fix the problem was mentioned.

Someone please help!