Thread: List, Sorting

I'm trying to make a drop down menu to sort/filter out a table.

So I selected a table and created a list, however, I don't want a drop down menu for every column and also, I want them to be visible when I click out of the table. The blue border is also not cool.

I tried googling, but found no results.

Can you post your sheet so that we can see what you are looking at? From your post I am not sure how that would be done to remove the filter upon clicking outside of the range. However you could put in a button or something on the sheet with the following macro that would remove any filters on your data

Sub RemoveFilter()
If ActiveSheet.AutoFilterMode = True Then ActiveSheet.AutoFilterMode = False
End Sub

Hope that helps.