Cannot remove filter in Excel 2010. The option it is grayed out.

Will_NYC
Will_NYC used Ask the Experts™
on
Cannot remove filter in Excel 2010. The option it is grayed out. See attached file.
Cannot-remove-filter-in-Excel-2010.pdf
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AlexSenior Infrastructure Analyst
Commented:
That's because it's not got a filter on there at the moment, you need to click data at the top and then the filter button
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Currently no filter is applied on your data set.
If you want to remove the filter option from the data set, go to the Data Tab and click the Filter button.
AlexSenior Infrastructure Analyst

Commented:
........
AlexSenior Infrastructure Analyst

Commented:
Excuse me wut!!!!!

Why didn't I get this?
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Excuse me wut!!!!!

Why didn't I get this?
You are right Alex. Your answer is same and when I read your answer, I didn't get what you were trying to say. That's probably because you wrote your answer very casually. But now when you pointed it out, I get what you meant. e.g. you wrote "you need to click data at the top" whereas I wrote "go to the Data Tab". Lol
But I think you should get the points. You should raise a ticket if OP doesn't award you points.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial