How do I see the current filter being applied in Excel?

I received an Excel document with a filter already applied. The header row does not show the dropdown buttons. RIght now I can uncheck the filter to see the entire dataset, and then hit undo to go back to the original view. Is it possible for me to see what the filter is so I can do more with the file?

8

3 Answers

As pointed out by gtwebb, the advanced filter dialog box showed a list range of Sheet1!$S$1, and led me to find the filter in Column S.

If you hover your mouse over the filter button you should see a text box indicating the current filter used.

I'm using Excel 2016.

1

every time there is filter applied, the row numbers [left side] will be in blue font color. If dat is REALLY filtered you will see that. If the row numbers are in black then no filters are applied. If you suspect some rows are HIDDEN, then you can unhide rows. hope this helps.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy