5

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 '14 at 11:57
  • I'm honestly not sure about it, but I added some clarifications which might help figure that out. – Alex Jun 12 '14 at 11:19
3

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.

| improve this answer | |

Your Answer

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

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