One of our customers shared to us an Excel Online document for exchanging notes and bug reports, the file is starting to grow quite a bit, and could benefit from filtering: one of the columns represents a "status" (To do, In progress, Done, Won't fix, etc.) but I can't find a way to apply the usual Excel filter which allows you to choose values and only show some rows.

Sample scenario: only show the rows in which the "status" column contains the value "To Do". In "offline" Excel, I'd simply use the "filter" function... Can it be done at all in Excel Online ?

Clarification: all the contents of the document are plain text, the only "magic" in place is that this 'Status' column changes background depending on what is written inside it (green for 'done', orange for 'todo', etc.

Clarification #2: I didn't realize before that the document comes from the customer's Sharepoint Online platform (I can see "Guest Contributor" on screen while I write), I don't know if it's relevant though. I cannot provide a link to the document, since it contains privileged information.

  • 1
    I can't find this "filter drop down" they refer to in the link
    – Alex
    Jun 10, 2014 at 11:57
  • I'm honestly not sure about it, but I added some clarifications which might help figure that out.
    – Alex
    Jun 12, 2014 at 11:19

1 Answer 1


I'm late in the party but not empty handed.

Yes, Excel online does support filtering.

Just format your column as table and then select the kind of filter you want to apply.

Refer to this technet for complete feature list.

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.