How to Keep Your Excel Filter View Separate from Other Users
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.
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.
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.
Open the shared workbook in WPS Spreadsheets and apply the filter or sort you want to use for your own view.
When the prompt appears, click See Just Mine. Your filter or sort is now saved as a temporary personal Sheet View.
Create or Select a Sheet View from the View Tab
Use this method when the filter prompt does not appear or when you want to manage your personal Sheet Views manually.
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. Open the shared workbook: Open the shared .xlsx workbook in WPS Spreadsheets.
- 2. Confirm supported storage: Save or confirm the workbook is stored in WPS Cloud, SharePoint, or OneDrive with co-authoring enabled.
- 3. Create a Sheet View: Go to the View tab and click Sheet View, then select New Sheet View.
- 4. Apply your personal filter: Apply filters or sorting. WPS keeps this view separate from other users.

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.




