How do I delete in the autofilter dropdown menu the sort options?

[tonychaoan]

When click on the auto filter drop down, the following 5 lines would show up and then the Text Filters shows. How do I hide those 5 lines so I can directly go to the Text Filters?

Sort A to Z
Sort Z to A
Sort by Color
Clear Filter from "customer"
Filter by Color

Thanks in advance for your help

 

[Jerry Sullivan]

Welcome to the Board, Tony.

I'm pretty sure that these menu items can't be deleted or hidden from the native AutoFilter function.

It's possible to use VBA controls to simulate some of the AutoFilter functionality with only a filter by Text...but that would be a lot of work and most likely not worth any benefit.