Keep Excel Filters Separate for Other Users with Sheet View
Question details
Keep one user's Excel filtering view separate while other users filter a shared workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users work in an Excel workbook stored on OneDrive and need to apply filters independently.
- Observed behavior
- Protecting individual filter cells does not lock one column's filter independently while leaving the other filters available.
Open the workbook from OneDrive in a version of Excel that supports Sheet View. Make sure the data has filter arrows, or select the data and choose Data > Filter.
Create a personal Excel Sheet View for filtering
Use Sheet View when collaborators need to sort or filter the same worksheet without changing one another's views.
Sheet View separates display choices; it does not lock a filter or prevent other users from accessing the underlying data.
Open the workbook from OneDrive in Excel and select the worksheet you want to filter.
On the View tab, open Sheet View and select New. Excel creates a temporary view for your work.
Use the filter arrows in the worksheet to select the values you want to see. Other users can create their own Sheet Views and apply different filters.
In the Sheet View controls on the View tab, select Keep and give the view a name so you can return to it later. Select Exit when you want to leave the view.

Use a separate protected report for fixed filter criteria
Use a separate report or dashboard when users must not change a particular report criterion.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making it easy to move everyday spreadsheet work across. It does not provide a fix for Excel's Sheet View or per-column filter-lock limitations.

Frequently Asked Questions
Can I lock one Excel column's filter and leave the others available?
Standard worksheet protection does not offer a per-column filter lock. For independent viewing, use View > Sheet View; for a fixed report criterion, consider a separate protected report.
Will my Sheet View stop other people from filtering?
No. Sheet View keeps your sorting and filtering view separate. Other users can create their own views and apply different filters.
How do I save a Sheet View for later?
After creating a temporary view through View > Sheet View > New, select Keep in the Sheet View controls and give the view a name.
Does Sheet View protect sensitive data?
No. Sheet View controls how data is displayed, not who can access it. Use OneDrive file-sharing permissions to restrict access to the workbook.




