To filter a shared Excel worksheet just for yourself, create a Sheet View first, then apply the filter while that view is active: choose View > Sheet View > New, then use the filter arrows in the header row. Your view keeps your filtering and sorting separate from the normal worksheet view, so collaborators can continue working with their own view of the data.
This is the right approach when a workbook is shared and you do not want your filter to rearrange or hide rows for other people. In an ordinary worksheet view, filtering and sorting can affect what collaborators see. Sheet Views are designed to let people working in the same workbook make their own changes to how they view the data.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a current version of Excel for the web or Mac that supports Sheet View.
- A workbook saved to OneDrive or SharePoint if you want to use Sheet Views while collaborating. Sheet Views are intended for workbooks stored in Microsoft cloud storage.
- A worksheet with a clear header row and a consistent block of data. The filter works best when each column has one heading and there are no completely blank rows or columns splitting the list.
- Edit access to the workbook. If it opens read-only, you may be able to view existing data but not create or keep your own view.
If you are working alone in a local workbook, you can use the regular Data filter instead. That filters the worksheet for your session, but it is not a separate personal view for multiple collaborators.
Step-by-Step
- Open the shared workbook and check where it is saved. Open the file from OneDrive or SharePoint, rather than editing a downloaded copy, if other people are collaborating in it. Confirm that you have editing permission. If Excel displays a read-only message, ask the file owner for access before trying to create a view.
- Go to the worksheet you want to filter. Sheet Views apply to a worksheet, so check the sheet tab at the bottom of Excel. If the data is on a different tab, select that tab before creating the view. Make sure the list has one header row, such as Date, Region, and Status, and that the headings are not blank.
- Create a new Sheet View before changing the data display. In Excel for Microsoft 365 on Windows, select View > Sheet View > New. Excel switches the worksheet into a new view, usually showing a view indicator near the sheet tabs or in the Sheet View menu. If Excel displays a message that you are in a temporary view, that is normal; you can keep the view after setting it up. Do not apply a regular filter or sort before entering Sheet View if you need to avoid changing the shared default view.
- Turn on filtering if the headings do not have filter arrows. While the new Sheet View is active, click a cell in the data list and choose Data > Filter. Excel adds a drop-down arrow to each column heading. If the arrows were already present, you can use them without toggling Filter off and on. Avoid selecting just one column of a larger table before turning on filtering, because that can leave other related columns outside the filter range.
- Choose the values you want to see. Select the arrow in the relevant heading. Clear Select All, tick the value or values you want to keep, and select OK. For example, in a Status column, select only Open to show open items. For text, number, or date conditions, use the options in the menu, such as Text Filters, Number Filters, or Date Filters, then enter the condition and confirm it. You can filter more than one column; Excel combines the choices so that displayed rows meet all active column filters.
- Check that the view is personal before continuing. Look at the Sheet View menu or the view indicator to confirm that your new view is active, not Default. If the workbook is shared, the active view name helps distinguish your personal arrangement from the normal worksheet view. A filter icon on a heading confirms that a filter is applied, but the icon by itself does not prove that you are in a Sheet View.
- Keep and name the view if you want to reuse it. If Excel marks the view as temporary, choose Keep when that option appears. To give the view a useful name, open View > Sheet View and use the view options to rename it, if available. Names such as Open Items or West Region make it easier to select the right view later. Save the workbook with Ctrl+S on Windows. Excel for Mac uses Command+S.
- Exit the personal view when you are done. Choose View > Sheet View > Exit to return to the default worksheet view. Exiting does not necessarily delete a saved view; it simply switches you out of it. When you want your filters again, open the Sheet View menu and select the named view. If you intend to remove a view permanently, use its options to delete it rather than merely exiting.
On a Mac, look for View > Sheet View and the filter command on the Data tab; names or ribbon placement can vary slightly by Excel version. In Excel for the web, use the View tab and its Sheet View controls, then apply the filter arrows in the worksheet. If you do not see Sheet View, check that you have a supported Excel version and that the workbook is saved in OneDrive or SharePoint.
Common Mistakes
- Filtering in Default view. This is the main way people accidentally affect collaborators. Before selecting a filter or sorting, use the Sheet View menu to confirm you are in a personal view rather than Default.
- Assuming a filter icon means the view is private. The filter icon only indicates that a filter is active. Check the active view name or indicator as well.
- Starting with an incomplete range. A blank row in the middle of a list, an empty heading, or selecting only part of the data can cause Excel to filter the wrong area. Remove unnecessary blank rows and include every related column.
- Expecting a view to follow you into a different copy. A view belongs to the workbook and worksheet, not to an exported PDF, a detached download, or an unrelated copy. Open the shared cloud workbook to use its saved Sheet Views.
- Thinking Exit deletes the view. Exit returns you to the default view. To remove a saved view, use the Sheet View options and choose the delete command, taking care not to remove a view someone else relies on.
- Using the same view name for different purposes. Clear names help you avoid applying the wrong saved filter. Name a view for its purpose or criteria, not simply View 1 if several people maintain views.
Tips
- Make your filter easy to understand. Use column headings that describe the contents clearly, such as Owner or Due Date. Headings make filter menus easier to interpret and help prevent accidental selections.
- Use multiple filters to narrow a list. For example, you can show records for one department and one status. The rows that remain must match both selections. To broaden the results, revisit each heading and adjust or clear its filter.
- Keep personal views focused. Create separate views for different recurring tasks, such as overdue items and items assigned to you, rather than continually changing one view. A descriptive name makes it clear which one to select.
- Use the clear-filter command when you want all rows back. Open the relevant heading menu and choose its clear-filter option, or use Data > Clear to clear filters on the sheet. Clear removes filter criteria; it does not delete the underlying records.
- Let collaborators know what you changed if the workbook is busy. Sheet Views separate display choices, but they do not create separate copies of the data. Editing cell contents still changes the shared workbook and may be visible to other people.
- Save and allow changes to sync. Cloud workbooks usually save automatically, but wait for Excel to finish syncing before closing the file or switching devices. This helps ensure a saved view is available the next time you open the workbook.
Troubleshooting
I cannot find Sheet View. First confirm that you are using a current Excel version that supports the feature and that you opened the workbook from OneDrive or SharePoint. In Windows, check the View tab for the Sheet View controls. If the workbook is an older file format, a protected workbook, or a read-only copy, save or open an editable supported copy in the cloud, if you have permission. Your organization may also restrict cloud collaboration features.
My filter seems to affect everyone. Check the active view immediately. If it says Default, switch to View > Sheet View > New before applying more filters. If you already changed the default display, clear the filter or restore the previous sort while in Default, then create a personal view and reapply your criteria. If other people are actively editing, coordinate with them before changing the default view back.
The filter arrows do not appear. Click in the data and select Data > Filter. Check that the heading row is included, that the sheet is not protected in a way that blocks filtering, and that the selected range includes the full list. If your data is an Excel table, its headings usually already have filter arrows. Do not add a second set by repeatedly toggling Filter.
Some expected rows disappear. Review every column with an active filter; criteria from different columns are combined. Open each filter menu and look for unchecked values or a condition you did not mean to set. Also check for hidden rows, inconsistent spelling, spaces at the end of text, and dates stored as text, which can make values appear in unexpected groups.
My view is gone after reopening the file. Check whether you kept a temporary view and whether the workbook finished syncing. Reopen the original cloud file, not a downloaded copy, then inspect the Sheet View menu for the view name. If it is missing, create the view again and use the Keep option if Excel presents it. If the workbook owner has restored an earlier version or changed access, ask them to check the file history and permissions.
I cannot edit or save my view. Confirm that the workbook is not read-only and that you have edit permission. If it is protected, the owner may need to allow the required actions or remove protection. If several people are using different Excel versions, ask them to open the cloud workbook in a version that supports Sheet Views; a feature may be unavailable or behave differently in an older application.
Frequently Asked Questions
Does filtering in a Sheet View change what coworkers see?
Sheet Views are designed to keep your sorting and filtering separate from the default view and other people’s views. However, edits to cell contents are still edits to the shared workbook, not private changes.
Can other people see my Sheet View?
Saved Sheet Views are part of the workbook, so collaborators with access may be able to see and select them. The view is personal in the sense that its filter and sort do not force everyone else into the same display, not in the sense that it is hidden or confidential.
Can I create more than one filter for myself?
Yes. Create and keep multiple Sheet Views, then give each a descriptive name. Each can have its own filter and sort arrangement, making it practical to switch between recurring ways of reviewing the same data.
Can I filter for my name in an Assigned To column?
Yes. In your active Sheet View, open the Assigned To filter menu, clear Select All, select your name, and choose OK. If names are spelled inconsistently or include extra spaces, some of your records may not match the selection.
Does a Sheet View change the data or delete hidden rows?
No. A filter hides rows that do not match the selected criteria; it does not remove them. To see them again, clear the filter or exit the view. Be careful not to select and delete rows if your intention is only to narrow what is displayed.
What if I only want to filter a workbook that is not shared?
You can use Data > Filter without creating a Sheet View. In a workbook you are using alone, that is usually sufficient. Sheet Views are most useful when you need your sorting and filtering to remain separate from collaborators’ worksheet displays.
Related
- Distinct Count in Excel PivotTables: How to Enable It
- How to Enable AutoSave in Excel for Automatic Saving
- How to Enable Copy and Paste in Excel When It Stops
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Weighted Average Calculator in Excel: Formula & ExamplesTo calculate a weighted average in Excel, multiply each value by its corresponding weight, add those products, and…
- How to Filter Multiple Dates in Excel by Range or ListTo filter multiple dates in Excel, turn on the column filters, open the arrow on your date column,…
- Excel XLOOKUP With Wildcards: Examples and TipsTo find a value when you know only part of the text, use XLOOKUP with wildcard match mode…
- Excel SUMIF with Dates: Rules, Examples, and FixesTo sum values for a date or date range in Excel, use SUMIF with a date criterion; for…
- Excel Filter for Specific Text: Steps and ExamplesTo filter Excel rows for specific text in Microsoft 365 on Windows, select a cell in your data,…
- Filter Only Bold Text in Excel with a Helper ColumnTo filter for bold cells in Excel, add a helper column that labels each cell as Bold or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.