Office Settings & Configuration

Filter Excel Cells Without Affecting Collaborators Using Sheet Views

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

The user wants to filter or sort a shared Excel worksheet without changing the view for other collaborators.

Filter Excel Cells Without Affecting Collaborators Using Sheet Views
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the shared workbook

Open the workbook from OneDrive or SharePoint in Excel for the web or a supported Excel desktop app.

2
Create a Sheet View

Select the worksheet, then go to View > Sheet View > New. Excel opens a temporary view for that sheet.

3
Apply your filter or sort

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.

4
Keep or exit the view

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.

Create a personal Sheet View before filtering or sorting
Sheet Views do not isolate cell edits: A Sheet View separates filtering and sorting, not changes to cell values. Edits to the workbook can still be visible to collaborators.
Free Microsoft Office alternative

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.

Filter and sort spreadsheet data using a familiar interfaceOpen and edit Microsoft Excel XLSX and XLS filesUse a free, lightweight office suiteMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

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.