Forum Discussion

MartinLeG's avatar
MartinLeG
Copper Contributor
Jan 24, 2022

Advanced Filters in Excel

Hi - we have an advanced filter in place on a shared Excel file - no idea how it got there but we can't get rid of it - and that means our standard filters are not filtering the entire data set. The 'clear' button is greyed out and if I click on the Advanced tab it is displaying list range: $A$1:$U$1. We just want to disable this and ideally prevent it ever being reapplied...

      • NowshadAhmed's avatar
        NowshadAhmed
        Iron Contributor
        I could be wrong but I am guessing your data is plain and no filter has been applied, hence the greyed 'clear' button.
        Select the headers and click on the 'Filter' button next to 'clear' button. Your standard filters will be back.
        Alternately, you can apply excel table format on your data. If it is already formatted as Table, go to design tab (shows when you click a data in the table) and check Filter Button check box.

        The range $A$1:$U$1 when clicking on Advanced filter is the data range excel sees, although your screenshots show data till P.

Resources