1

The filter function in the Excel web app simply doesn't work. Here I'm choosing to show all statuses except Done, and it shows it anyway:

spreadsheet

There actually are some rows with a status of Done that are hidden, but I can't see any pattern to it. There's nothing special about this row, as far as I can see.

1
  • 1
    I have, and it doesn't help. Commented Sep 10, 2014 at 22:04

1 Answer 1

4

I figured it out, almost by accident. You see how in the original screenshot, the row colors alternate but then stop at row 23. That's because the "table" part of the worksheet only included the top rows, and the filtering only works on those rows. I had to reformat ALL of my data as a table, and now it works. This is really non-obvious.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.