Excel 2010 - sorting/filter dropdown

[frankhov1n]

I'm trying to add a sorting filter dropdown on some columns in a sheet. If I select the column, then use Data -> Filter, it adds the filter. on that column. But then, if I select another column, the "Filter" button in the tool menu is already selected, even though there is no filter for that column. If I click it, the filter on the other column disappears. Then, clicking it again adds a filter for every single column. It seems I'm not able to select f.ex. 3 different columns and add a filter to only those. It's either all or none. Is this how it's supposed to work?

Sorry if I'm explaining this poorly. For some reason, I find it a bit difficult to explain it as clearly as I want

[frankhov1n]

BUMP! Isn't this quite basic?

[Fotis1991]

Hello

Looks like quite basic but it isn't as you have problem.

A small sample workbook showing the problem will help us to help you.