View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default How do I clear an Advanced Filter

Manually unhide the rows

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ChipInTampa" wrote in message
...
I accidentally added an Advanced filter for part of a range. I cannot
clear
it or remove it using either:
a) the advanced filter dialog
b) the clear toolbar icon

I am trying to auto filter the range, that does not work either because
part
of the range has the advanced filter.