Office Settings & Configuration

How to Keep Your Excel Filter View Separate from Other Users

Anum MushtaqAnum Mushtaq Nov 13, 2026 868 views

Question details

The user wants to apply a personal filter or sort in a shared Excel workbook without changing the view seen by other co-authors.

Product
WPS Spreadsheets
Device & OS
not provided
Scenario
Co-authoring a shared workbook and needing to filter or sort data for personal use only.
Observed behavior
After applying a filter, the prompt to choose See Just Mine may not appear, or the user needs to open Sheet View manually.
Before you start

Make sure the shared workbook is saved in a location that supports Sheet Views, such as WPS Cloud, SharePoint, or OneDrive, and confirm that co-authoring is active before you apply filters or sorting.

Solution 1Recommended

Select See Just Mine When the Filter Prompt Appears

Use this method when WPS Spreadsheets or Excel shows the Sheet View prompt immediately after you apply a filter in a shared workbook.

When co-authoring is active, applying a filter or sort can change the shared default view. The See Just Mine option keeps your filter or sort as a temporary personal view that other users do not see.

1
Apply the filter or sort

Open the shared workbook in WPS Spreadsheets and apply the filter or sort you want to use for your own view.

2
Choose See Just Mine

When the prompt appears, click See Just Mine. Your filter or sort is now saved as a temporary personal Sheet View.

Prompt does not appear?: If the prompt does not appear, use the View tab method in the next solution to create a Sheet View manually.
Use WPS Spreadsheets

Keep Personal Filters Separate in WPS Spreadsheets

Use Sheet View in WPS Spreadsheets to apply personal filters and sorting in a shared workbook without affecting other co-authors.

  1. 1. Open the shared workbook: Open the shared .xlsx workbook in WPS Spreadsheets.
  2. 2. Confirm supported storage: Save or confirm the workbook is stored in WPS Cloud, SharePoint, or OneDrive with co-authoring enabled.
  3. 3. Create a Sheet View: Go to the View tab and click Sheet View, then select New Sheet View.
  4. 4. Apply your personal filter: Apply filters or sorting. WPS keeps this view separate from other users.
Personal Sheet Views keep filters and sorts visible only to you.Works with Microsoft Excel .xlsx files for smooth collaboration.Familiar ribbon and View tab tools make switching views quick.Free office suite with no extra add-ins required.
microsoft office alternative - wps office

Frequently Asked Questions

Why don't I see the See Just Mine prompt after filtering?

The prompt may not appear if co-authoring is inactive or the file is not stored in a supported cloud location. Open the View tab and create a Sheet View manually, and confirm the workbook is saved in WPS Cloud, SharePoint, or OneDrive.

Where is Sheet View in WPS Spreadsheets?

Go to the View tab on the ribbon and click Sheet View. From there you can create a new personal Sheet View or switch between existing Sheet Views.

Will my filter affect other users in a shared workbook?

Not when you use a personal Sheet View. Other users see the default view unless you change the workbook without creating or selecting a personal Sheet View.

Does WPS Spreadsheets support Excel Sheet Views?

Yes. WPS Spreadsheets can work with .xlsx workbooks and provides Sheet View on the View tab for compatible shared workbooks.

How do I exit my personal Sheet View?

Open the View tab, click Sheet View, and select Default View or another view from the list.