File Sharing Problems

Use Excel Sheet Views for Personal Filters and Hidden Rows

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

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.

Use Excel Sheet Views for Personal Filters and Hidden Rows
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a view

On the worksheet, select View > Sheet View > New.

2
Adjust your display

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.

3
Save the view

In the Sheet View controls, select Keep and enter a name so you can return to the view later.

4
Switch views when needed

Use the Sheet View selector on the View tab to reopen a saved view, or select Exit to leave the current view.

Create a personal Excel Sheet View
See Just Mine: If Excel prompts you while another person is filtering, choose See Just Mine to work in your own view. Do not assume this choice can be set as a default in every Excel version.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX filesUse familiar spreadsheet filters to organize dataNavigate a familiar office-style interfaceMove existing spreadsheets into a lightweight office suite
microsoft office alternative - wps office

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.