Share via

How do I change the filters on a shared Excel Online without messing the filter that a coworker has set?

Anonymous
2022-11-09T16:59:52+00:00

When we are both working on the spreadsheet, there are times when we need to work with separate filters, but when I make a change to the filter, it also changes on her end or vice versa. I was wondering if there is a way that we can both work on it at the same time, with different filters without messing each other's settings up.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-11-09T18:09:25+00:00

    Dear AnaPD,

    Thanks for posting in Microsoft community. We are glad to help you.

    You could try the sheet view feature to create a view for yourself in a co-authoring Excel file:

    For reference: Create and manage Sheet Views in Excel (microsoft.com)

    Thanks for your understanding and cooperation! Hope you are keeping safe and well.

    Sincerely,

    Sean | Microsoft Community Moderator

    0 comments