Yes. In Excel for Microsoft 365, use a Sheet View before filtering: open the View tab, choose Sheet View > New, then apply your filters. Your filter and sort choices stay in your view instead of changing the view coworkers are using.
Why a normal filter can affect coworkers
A filter hides rows on a worksheet; it does not make a separate copy of the data. In a coauthored workbook, a regular filter or sort can change what other people see on that sheet. A colleague may think records have disappeared, or may find the rows in a different order while trying to work.
That does not necessarily mean the rows were deleted. Clear the filter or remove the sort to show the underlying records again. Still, changing a shared view can interrupt other people, particularly when several collaborators are reviewing the same list at once.
Sheet View is designed for this situation. It lets each collaborator create a view with their own filters and sorting while other collaborators can use different views or the default worksheet view. For example, you could show only open orders assigned to you while a teammate reviews all orders by date.
How to set up a personal Sheet View
For the feature to work as intended, open the workbook in a supported, coauthored format, typically an .xlsx file stored in OneDrive or SharePoint. Then start a Sheet View before applying a filter. On Windows, use these steps:
- Open the shared workbook in Excel for Microsoft 365 and select the worksheet containing the list.
- Choose View > Sheet View > New. Excel switches the worksheet into a separate view.
- Apply a filter using the column’s filter arrow. If the range does not have filter arrows, select the list and choose Data > Filter while in your Sheet View.
- Choose the values or conditions you want to see. You can also sort within the view if that helps your task.
- If you want to reuse the view, give it a recognizable name or keep it when Excel offers that option. To return to the normal worksheet view, choose View > Sheet View > Exit.
Menu wording and placement can vary slightly with Excel updates, and Excel may show a Sheet View selector when a view is active. Use that selector to switch between available views. On Mac and Excel for the web, the feature is also available in supported versions, but the ribbon layout can differ; look on the View tab for Sheet View. If the command is missing, check the workbook and version requirements below.
What your view changes—and what it does not
A Sheet View keeps view-level choices such as your filter and sort from disrupting another person’s view of the worksheet. It is useful for exploring the same shared list in different ways without creating duplicate copies of the data. If you filter to show only “Open” orders, for instance, coworkers can still review the full list or create a different filter.
It is not a separate private worksheet or a private copy of the workbook. Sheet Views are saved with the workbook, and other people with access may be able to see or use available views. More importantly, filtering is not a security feature: it hides rows from the current display but does not prevent someone with workbook access from viewing the data by changing a filter or opening another view.
Nor does a Sheet View isolate every worksheet action. Editing cell values changes the shared workbook data. Formatting, inserting or deleting rows, changing formulas, and other structural edits are not made private merely because you are in a Sheet View. Treat the feature as a way to separate how data is displayed—not as a way to work on an independent version.
Requirements and the legacy Shared Workbook feature
Sheet Views are intended for modern coauthoring. The workbook generally needs to be saved in OneDrive or SharePoint, and collaborators need Excel versions that support coauthoring and Sheet Views. An older file type, a local-only file, or an older Excel installation can prevent the feature from appearing or working as expected. Saving a compatible copy as .xlsx and opening it from supported cloud storage may resolve the issue, provided your organization permits that change.
Do not confuse modern coauthoring with Excel’s older Shared Workbook (Legacy) feature. That legacy mode is different from sharing a workbook through OneDrive or SharePoint and has limitations. It is not the route to use for a personal filter view. If you inherit a workbook using the legacy feature, ask its owner or administrator about moving to modern coauthoring before changing how it is shared.
Sheet View availability also depends on the Excel edition and update level. Microsoft 365 versions of Excel for Windows, Mac, and the web support Sheet Views, though specific controls may differ. If you are using a perpetual or older edition, check its current feature support rather than assuming that every Excel version has the same commands.
Choosing between Sheet View and other approaches
For ordinary shared analysis, Sheet View is usually the simplest option. Choose another approach when you need a different kind of separation:
- Sheet View: Best when you and coworkers need different filters or sort orders on the same shared worksheet.
- A regular filter: Fine when you are working alone or when everyone agrees to use the same displayed rows. In a shared session, it can alter the view for others.
- A separate worksheet or workbook: Useful when you need a distinct report or a different layout. A copied list may become outdated when the source data changes, so make clear which copy is authoritative.
- Permissions or a separate file: Necessary when some users should not be able to access particular records. Hiding rows with a filter is not access control.
Consider an inventory workbook with columns for Item, Warehouse, Status, and Quantity. You might create a Sheet View filtered to Warehouse = North and Status = Reorder. A coworker could use a different view to check every item at the South warehouse. Both views work from the same underlying records; neither filter removes inventory data or restricts access to it.
Common problems and how to fix them
- Sheet View is missing: Confirm that you are in a supported Excel version and that the workbook is saved in OneDrive or SharePoint for coauthoring. Also check whether it is an older file format or uses Shared Workbook (Legacy).
- Your filter still changes what coworkers see: Check that you created a Sheet View before filtering and that the Sheet View selector shows your view as active. If you applied the filter in the default view first, exit or clear that view as appropriate, create a new Sheet View, and apply the filter again.
- You cannot filter the expected range: Make sure the list has a single header row and no completely blank rows splitting the data. Select the intended range and use Data > Filter while in your Sheet View.
- Rows seem to be missing: Review each active column filter, including filters that may have been set earlier. Clear filters to display all records; do not assume that a filtered-out row was deleted.
- A view or result changes after someone edits data: Sheet Views separate display choices, not the shared data. A coworker’s edit can change whether a record meets your filter, so refresh your understanding of the current list and coordinate edits when needed.
If an unexpected shared filter has already been applied, avoid making more changes until you know which view is active. Switching to a new Sheet View and setting your filter there is safer than repeatedly changing the default worksheet view while coworkers are using it.
Good habits for collaborating with filtered data
Give saved views descriptive names, such as “North warehouse — reorder,” rather than generic names that are hard to identify. Keep filters focused on the task, and make sure your view is active before sorting a large list. If coworkers rely on the default view, tell them when you are changing a regular filter rather than a Sheet View.
When the filtered list is used for decisions, verify the criteria before acting. A filter on “Status” may exclude blank cells, while a text filter may include or omit values depending on spelling and spacing. Check totals against the unfiltered data when the result matters, and remember that other users can edit records while you are viewing them.
Frequently Asked Questions
Can I filter a shared Excel workbook without affecting others?
Yes. Create a Sheet View with View > Sheet View > New before applying the filter. A regular filter in the default view may affect what collaborators see.
Can other people see my Sheet View?
Sheet Views are saved in the shared workbook, so other people with access may be able to see or use them. They keep your filter or sort from taking over another person’s view; they do not make the view or its underlying data confidential.
Why don’t I see Sheet View in Excel?
The workbook may not be in a supported format or cloud location, or your Excel version may not support the feature. Check that it is an .xlsx workbook in OneDrive or SharePoint and that you are using a supported, updated Excel version.
Does a Sheet View hide data from coworkers?
No. It changes how rows are displayed, not who can access the workbook’s data. Use appropriate permissions or separate files if certain people must not have access to particular information.
Can I use a personal filter view in Excel for the web or Mac?
Supported versions of Excel for the web and Mac offer Sheet Views. Look on the View tab for the Sheet View controls; their location and appearance may differ from Excel for Windows.
Related
- Excel Power Query: Enable Background Refresh
- Excel Power Query: Delete Duplicate Rows
- Excel Power Query: Combine Files From a Folder Easily
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Conditional Formatting Formula for Due Dates ExplainedIn Excel for Microsoft 365 on Windows, select the cells to format, choose Home > Conditional Formatting >…
- Excel SUM Function: Does It Count Filtered Values?Yes. In Excel for Microsoft 365, SUM adds every numeric value in its referenced range, including values in…
- Extract Part of Text in Excel: Formulas and StepsTo extract part of text in Excel, use LEFT, RIGHT, or MID for characters in known positions, and…
- Excel Formula for Percentage Between Two Cells ExplainedTo find what percentage one cell is of another in Excel, divide the first cell by the second:…
- Excel Days Until Date: Formulas, Examples, and FixesTo calculate calendar days until a date in Excel, subtract today’s date from the target date: with the…
- Excel LAMBDA in Name Manager: How to Create and Use ItYes. In Microsoft 365 Excel for Windows, you can save a LAMBDA formula as a defined name in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.