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
LVL 1
McottuliAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Harry LeeCommented:
Mcottuli,

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.
0
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.