Use Excel Sheet Views for Personal Filters and Hidden Rows
Question details
The user wants a personal view for filtering and hiding rows or columns while co-authoring an Excel workbook, and wants to know whether See Just Mine can be the default.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A team is co-authoring a large workbook and needs individual views that do not disrupt other collaborators.
- Observed behavior
- The desired outcome is for each collaborator to filter or hide data independently, with See Just Mine selected by default if supported.
Open the shared workbook in a version of Excel that supports Sheet Views, and check that it is stored in OneDrive or SharePoint. Select the worksheet where you want to create your personal view.
Create a personal Excel Sheet View
Use a Sheet View to filter or hide rows and columns without changing other collaborators' views.
Sheet Views control how a worksheet is displayed; they do not make cell edits private. Changes to cell contents are saved to the shared workbook.
On the worksheet, select View > Sheet View > New.
Use the filter arrows in your data to choose what to display. To hide rows or columns, select their headers, right-click, and choose Hide.
In the Sheet View controls, select Keep and enter a name so you can return to the view later.
Use the Sheet View selector on the View tab to reopen a saved view, or select Exit to leave the current view.

Request unavailable default or permission controls
Use Microsoft feedback or support if your team needs a default See Just Mine setting or Sheet View permissions that are not available.
Work with Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Its Excel format compatibility makes it easier to move existing files to WPS, though it does not change Microsoft Excel's Sheet View settings or permissions.

Frequently Asked Questions
How do I create my own filter view in Excel?
Select the worksheet, then go to View > Sheet View > New. Apply your filters and select Keep if you want to save the view.
Can I make See Just Mine the default?
Excel may offer See Just Mine when another person is filtering, but a default setting is not available in every version. Use File > Feedback to request it if your version does not provide the control.
Are cell edits private in a Sheet View?
No. A Sheet View changes the worksheet display, but edits to cell contents are saved to the shared workbook and can affect collaborators.
What should I check if Sheet View is unavailable?
Check that your Excel version supports Sheet Views and that the workbook is stored in OneDrive or SharePoint. If the option is still missing, contact Microsoft support with your Excel version and storage details.




