Unable to clear an advanced filter

Question

Hello,   Good evening everyone ;)  I'm unable to remove an advanced filter in Excel…  When I click on the filter tool, the "clear filter" option is grayed out and inaccessible!  Can someone please advise me?  Thank you  Configuration: Macintosh / Safari 13.0.3

Yoyo01000 · Answer

Hello, is the sheet and/or the workbook locked?  -- It's not only salsa, bachata, and kizomba in life. There's also Excel ^^

Frenchie83 · Answer

Hello,  If it's a filtered area other than on-site, simply select that area and press "DEL".  Now, regarding your previous post, here’s a suggestion that might interest you.  -Enter your advanced filter criteria (up to 6 lines of criteria), do not touch the "O" column. -Click on the "Apply advanced filter" button.  The code used: Sub Filtre_Avance() Application.ScreenUpdating = False Range("I12:N100").Clear 'Clear previous filter DerLig = Range("A" & Rows.Count).End(xlUp).Row 'Last row of the database DerLig_Fil = Application.WorksheetFunction.CountIf(Range("O3:O8"), "YES") + 2 'detects the last line of the advanced filter area Range("A1:F" & DerLig).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("I2:N" & DerLig_Fil), CopyToRange:=Range("I11:N11"), Unique:=True End Sub  The example file with 4 choice criteria https://mon-partage.fr/f/sMl9yTBZ/  Best regards

ptéranodon · Answer

Thank you Yoyo ;)  No, the sheet is not protected…  Thank you Frenchie ;)  If it’s a filtered area other than on-site,   -What do you mean by "other than on-site"?  just select that area and press "DELETE".  -You mean: Select the table Click on the fn key and delete (backward arrow) or just delete (I’m on Mac.)  It doesn’t work…  > Why is the "delete" function in the "data" tab of the advanced filter greyed out??

Frenchie83 · Answer

Hello,  -What do you mean by "other than on-site"?  The advanced filter can be applied in two different ways, either by filtering the area to be filtered or by reporting it to another location. You have the choice when you select "advanced filter"  If it's the second scenario, select the filtered result and delete it with fn and backspace (reverse arrow) since you are on Mac.  But the file I returned to you doesn't work? In this file, there is an application of advanced filters with multiple criteria in the range I3:N8, after clicking the button the result is found in I12:N16, if you select this area and press fn and backspace (reverse arrow), does it not erase?  The macro provided and linked to the "Apply advanced filter" button performs this erase maneuver before displaying a new view based on the selected criteria.   I can't see it any simpler Best regards

ptéranodon · Answer

Hello via.  When I clear the filtered range (fn-supp) and click "ok," I get the message "invalid reference"!

Frenchie83 · Answer

Not working on a Mac, I don't understand, do you get a message when you delete? Is this specific to Mac?  Does the provided file match what you need? -If so, did you just click the button? (I remind you that the macro handles the deletion).

ptéranodon · Answer

Good evening Frenchie ;)  Sorry for the late reply. I finally found the trick to clear a multi-criteria filter in Excel on a Mac:  1-Open the advanced filter box (funnel icon in the "data" tab ribbon)  2-Clear the ranges in the open filter window  3-Click on "cancel" at the bottom of the window  >4-Click the funnel again  Thanks again for the macro. Great!

Unable to clear an advanced filter

7 réponses

Windows spotlight is not working.

Samsung j5 unable to answer

Scam of the suvedene highway

Remove 360 antivirus

My pc's screen is flickering.

Fujitsu siemens laptop won't start anymore

Wearline: what do you think?

Eko tank smartwatch

Ibiza sound reviews

Only one of my iphone headphones works. what to do?