What it does
These macros will either show or hide the AutoFilter arrows in columns you specify.

When to use it
Any time you want to hide the AutoFilter arrows from being visually displayed (the filters themselves remain in effect).

Why to use it
Generally the arrows are hidden when the table of data (including headers) is copied to a PowerPoint slide, a Word document, an email, etc. Hiding the arrows in screenshots is considered a more professional look.

Default shortcut
None

Other Details

• Category: Filter and Sort / Filter
• Difficulty: 3/5
• Usage/frequency: 2/5
• Automation factor: 4/5 (estimated 5 seconds saved each time used)
• Type: Shortcut
• Date added: 5/9/2017
• Tags: Filter, arrows

Related Macros
Filter Picker

Other Articles
None

None

Prerequisites
Apply AutoFilter to the range that should be filtered and apply filters to any columns you’d like.

Instructions
Select cell(s) in the column(s) for which you want to hide or show the AutoFilter arrows.  Then run the Hide AutoFilter Arrows macro to hide filter arrows in the selected columns.  Run the Show AutoFilter Arrows macro to show filter arrows in the selected columns.