{"id":27606,"date":"2022-09-08T02:57:20","date_gmt":"2022-09-08T02:57:20","guid":{"rendered":"https:\/\/excelevate.co\/wp\/?page_id=27606"},"modified":"2022-09-14T02:24:41","modified_gmt":"2022-09-14T02:24:41","slug":"xlev8-manual-show-hide-af-arrows","status":"publish","type":"page","link":"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-show-hide-af-arrows\/","title":{"rendered":"XLEV8 MANUAL: SHOW HIDE AUTOFILTER ARROWS"},"content":{"rendered":"

<\/p>[et_pb_section fb_built=\u201d1\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d custom_padding=\u201d0px|||||\u201d global_colors_info=\u201d{}\u201d][et_pb_row _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d min_height=\u201d28.8px\u201d global_colors_info=\u201d{}\u201d]\n

XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n

\u00a0<\/p>\n

SHOW AUTOFILTER ARROWS \/ HIDE AUTOFILTER ARROWS<\/h2>\n

[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n

What it does<\/strong><\/span>
These macros will either show or hide the AutoFilter arrows in columns you specify.<\/p>\n

When to use it<\/strong><\/span>
Any time you want to hide the AutoFilter arrows from being visually displayed (the filters themselves remain in effect).<\/p>\n

Why to use it<\/strong><\/span>
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.<\/p>\n

Default shortcut<\/strong><\/span>
None<\/span><\/strong><\/p>\n

Other Details<\/strong><\/span><\/p>\n

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

    [\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n

    Related Macros<\/strong>
    Filter Picker<\/p>\n

    Other Articles<\/strong>
    None<\/p>\n

    [\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n

    None<\/p>\n

    [\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n

    Prerequisites<\/strong>
    Apply AutoFilter to the range that should be filtered and apply filters to any columns you\u2019d like.<\/p>\n

    Instructions
    <\/strong>Select cell(s) in the column(s) for which you want to hide or show the AutoFilter arrows.\u00a0 Then run the Hide AutoFilter Arrows<\/strong> macro to hide filter arrows in the selected columns.\u00a0 Run the Show AutoFilter Arrows<\/strong> macro to show filter arrows in the selected columns.<\/p>\n

    [\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]<\/p>\n

    \n
    \n
    \"\"

    Screenshot of Show AutoFilter Arrows macro.<\/p><\/div>\n

    \"\"

    Screenshot of Hide AutoFilter Arrows macro.<\/p><\/div>\n<\/div>\n<\/div>\n

    [\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]