• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 15157
  • Last Modified:

Cannot remove filter in Excel 2010, it is grayed out.

I am using excel 2010 and I only need to add filters to the first 2 columns in my spreadsheet.  When I select the data that needs filtering, click the filter button it also includes the 3rd column and I don't need a filter on that one.  When I right click on the 3rd column to remove filter, it is grayed out.  How do I fix this?  Thank you
  • 2
3 Solutions
Rory ArchibaldCommented:
What option are you actually trying to select? The "Clear filter" option? That's only available when you have actually filtered on that column.

Also, if your data is a table, you will get filters on all columns.
Ejgil HedegaardCommented:
Select the data in the first 2 columns before applying filter.
If nothing is selected, Excel use all cells connected to the active cell until the range meet empty cells.
If a range is selected, that is used.
Harry LeeCommented:

I don't see a point for you to worry about this at all. In fact, if you don't need to use the filter in Column C, just ignore it.

The way Excel work is basically hide the rows that does not meet the set criteria. Regardless you have filter on Column C or not, when you filter Column A, and Column B, some rows in Column C is going to be hidden.

If you really don't want the extra Pointing-Down-Triangle to appear on Column C header, you can follow hgholt's suggestion.

If you want the filter only to affect Column A and Column B, but not Column C, AutoFilter is not what you need.
Ejgil HedegaardCommented:
I generally agree with HarryHYLee, to ignore the filter option on column C if it is not needed, but can imagine a solution where it could be relevant not to have it.
The sheet is distributed, protected with autofilter allowed, and other columns is the result of the selection for columns A and B, so the user must only be able to filter A and B.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now