Formatted Tables & Filter Buttons

Question

Once I select the "Format As Table" option for my existing data, is it possible to remove or hide the filter button from individual columns within the table while leaving others?

Answer 1

Dear Herschel Neel,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, it seems that you want to remove or hide the filter button in formatted table for individual columns within the table while leaving others.

If the understanding above is right, per the search and testing, we're afraid that there's no out of box way to achieve this requirement currently. For your reference: Clear or remove a filter - Microsoft Support

Given this situation, we've found this VBA code as a workaround, it hide the arrows in every third column of Table1.

Sub HideArrows()
  Dim i As Long
  
  With ActiveSheet.ListObjects("Table1").Range
    For i = 1 To .Columns.Count
      .AutoFilter Field:=i, VisibleDropDown:=i Mod 3 > 0
    Next i
  End With
End Sub

If you want to know more about Power Automate solutions, considering that our forum is mainly focus on the general troubleshooting steps with office 365 products, you can refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflow by using the VBA tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there.

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.

At the same time, we will also keep this thread open, so other Community members and Experts can also share their suggestions and inputs.

Thank you for your cooperation and understanding!

Sincerely,

Rhoda | Microsoft Community Moderator