Office Settings & Configuration

Keep Excel Filters Separate for Other Users with Sheet View

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

Keep one user's Excel filtering view separate while other users filter a shared workbook.

Keep Excel Filters Separate for Other Users with Sheet View
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the shared workbook

Open the workbook from OneDrive in Excel and select the worksheet you want to filter.

2
Create a Sheet View

On the View tab, open Sheet View and select New. Excel creates a temporary view for your work.

3
Apply your filters

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.

4
Keep the view if needed

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.

Create a personal Excel Sheet View for filtering
Sheet View is not a per-column lock: Standard worksheet protection does not provide an independent lock for one column's filter while leaving all other filters available.
Free Microsoft Office alternative

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.

Sort and filter spreadsheet data in WPS SpreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday spreadsheet tasksMove existing Office files into a lightweight, free suite
microsoft office alternative - wps office

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.