Filter Excel Cells Without Affecting Collaborators Using Sheet Views
Question details
The user wants to filter or sort a shared Excel worksheet without changing the view for other collaborators.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple people are working in the same worksheet and need to see different filtered or sorted data.
- Observed behavior
- Each collaborator can use a separate Sheet View to apply their own filters and sorting.
Make sure the workbook is shared and stored on OneDrive or SharePoint, and check that your Excel version has a View > Sheet View option. Sheet Views are available in Excel for the web and supported Microsoft 365 desktop versions.
Create a personal Sheet View before filtering or sorting
Use this method to work with your own worksheet view while others collaborate in the same workbook.
Open the workbook from OneDrive or SharePoint in Excel for the web or a supported Excel desktop app.
Select the worksheet, then go to View > Sheet View > New. Excel opens a temporary view for that sheet.
Select a filter arrow in the table or filtered range, then choose the values or sort order you want. These view settings stay separate from collaborators' views.
Use View > Sheet View > Keep to save the temporary view, or choose Exit to return to the default view. You can select a saved view from the Sheet View menu later.

Use Excel for the web if Sheet View is unavailable on desktop
Open the shared file in a browser when your desktop version does not show the Sheet View controls.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. Excel Sheet Views are an Excel feature; WPS does not fix their availability in Excel or guarantee equivalent independent collaborative views.

Frequently Asked Questions
Will my Sheet View filters change what other people see?
Filters and sorting applied in your personal Sheet View are separate from other collaborators' views. Create the view with View > Sheet View > New before filtering.
Can I use Sheet Views in desktop Excel?
Sheet Views are available in supported Microsoft 365 desktop versions as well as Excel for the web. Look for View > Sheet View; if it is unavailable, try opening the shared workbook in Excel for the web.
How do I save a temporary Sheet View?
While the temporary view is active, select View > Sheet View > Keep. You can return to the saved view from the Sheet View menu.
Are cell edits private in a Sheet View?
No. Sheet Views separate filtering and sorting, but edits to cells remain changes to the shared workbook and can be visible to collaborators.




