Managing filtered data

[Libra0099]

Hello everyone.

I am working on a shared excel work sheet used by different users.

This work sheet have more than 70 Columns. Auto filters are used by different users according to their needs. Whenever I or new user access this worksheet we found this filtered by last user.

How can I easily find out the column on which filter is used?

 

[brian.wethington]

Is it really important to know what column it is used to filter? Or can you just turn off the filter?

Data, Filter, Autofilter

 

[Libra0099]

Yes Brain you are right. I agree with you.

But I want to know is there any short key or some other way to check filtered column.

Because it very time consuming to see all the columns but still I dont want to turn off filters.