+ Reply to Thread
Results 1 to 2 of 2

Remove Table Filter Arrows on some Columns

  1. #1
    Registered User
    Join Date
    05-01-2009
    Location
    Madrid, Spain
    MS-Off Ver
    Excel 2007
    Posts
    4

    Remove Table Filter Arrows on some Columns

    Hi,

    I made a budget with many narrow columns and have turned the data into a table. I will only ever filter the data with the left-hand most column. However, all the other columns are filled each with the grey drop-down filter arrow button, and I can no longer see the headings of these columns and frankly seeing 50 little unused arrow buttons is rather ugly. Is there any way to simply remove the filter drop-down buttons on some columns or even all of them, just leaving a filter button at the heading of the first column? I know I can hide the headings, but then I lose sight of the first filter arrow that I use.

    Sorry to ask such a bizarre question, but I appreciate your help.

    Thanks

  2. #2
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: Remove Table Filter Arrows on some Columns

    Remove all the auto filters,

    Hightlight the columns you want the filters on and re apply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1