How to Filter in Excel Only for Yourself with Sheet Views

Formulas & functions · Updated November 20, 2026

To filter a shared Excel workbook without changing what coworkers see, open the View tab, choose Sheet View > New, and then filter the data as usual. This creates a separate view for your sorting and filters while leaving other people’s views alone. For the most reliable collaboration, the workbook should be saved to OneDrive or SharePoint and opened in a current version of Excel for Microsoft 365.

What You’ll Need

  • A workbook with a clear header row and a data range or Excel table you want to filter.
  • Excel for Microsoft 365 on Windows, or Excel for the web. The workbook should be saved in OneDrive or SharePoint so the shared file and Sheet Views are available to collaborators.
  • Edit access to the workbook if you need to create or save a Sheet View. If you only have read access, you may not be able to create one.

Sheet Views are designed for filtering and sorting shared worksheets independently. They do not make your edits to cell contents private: when you change a value in a shared workbook, that change is still part of the workbook and can be seen by other people.

Step-by-Step

  1. Open the shared workbook. Open the file from its OneDrive or SharePoint location, rather than opening an unrelated downloaded copy. In Excel for Microsoft 365 on Windows, confirm that the workbook is saved in a supported modern format such as .xlsx or .xlsm. If the workbook is read-only, ask its owner for edit access before trying to create a saved view.
  2. Go to the worksheet with the data. Select the worksheet tab containing the list or table you want to filter. Sheet Views apply to a worksheet, so choosing the correct tab matters. If the workbook has several similar tabs, check the headings and records before continuing.
  3. Create your own Sheet View before filtering. On the ribbon, select View > Sheet View > New. Excel switches the worksheet into a separate view. Look for an indication that a temporary Sheet View is active, such as a temporary-view label or a changed Sheet View control. Create the view first; applying an ordinary filter before entering a Sheet View can change the shared worksheet view for other collaborators.
  4. Turn on filter controls if the data does not already have them. If the range is an Excel table, its header row normally has filter arrows already. For a regular range with one header row, click a cell in the data and choose Data > Filter. Check that Excel has identified the full range and that the header row is included. You should see a drop-down arrow in each header cell.
  5. Choose a filter in the relevant column. Select the arrow beside a header, then choose the values or conditions you want. For a list of values, clear Select All and select the items to display. For numbers or dates, use the available number or date filters, such as a comparison, range, or period. Select OK to apply the choices. For example, in a table with Department, Region, and Status columns, you can show only the Sales department and then select Open in the Status column.
  6. Check the result and add other criteria as needed. A filter on a second column further narrows the displayed rows; it does not replace the first filter. In the example above, choosing a region after Sales and Open shows records that match all three selections. Review the visible records and the row numbers to confirm that the result makes sense. Filter arrows or icons can indicate which columns have filters applied.
  7. Save or name the view if you want to reuse it. Sheet Views can be temporary or saved with the workbook, depending on the controls shown in your Excel build. If Excel shows a Keep option for the temporary view, select it to retain the view. To give a saved view a useful name, open the Sheet View menu on the View tab and use the rename option if it is available. Names such as Open sales by region are easier to recognize than View 1.
  8. Return to the normal view when you are finished. Use View > Sheet View > Exit, or select the exit control shown for the active view. Your filters may no longer be displayed after you exit, because the normal worksheet view is separate. To use the same personal filter later, select the saved Sheet View from the Sheet View menu. If the view was temporary and you did not keep it, you may need to set it up again.

Excel for the web: Open the workbook in a browser, select View > Sheet View > New, and apply filters from the header drop-downs. The exact placement or wording of controls can vary slightly with the web interface, but the sequence is the same: enter a Sheet View before filtering, then keep or name it if you want it to be reusable. On Excel for Mac, use the View tab and its Sheet View controls where the feature is available. If you cannot find Sheet View, check that you are signed in, using a supported Microsoft 365 version, and working with a cloud-saved file.

Common Mistakes

  • Filtering before creating the Sheet View. This is the most important timing issue. A standard filter or sort can affect the shared worksheet view. Create or select your Sheet View first, then apply the filter.
  • Expecting a Sheet View to hide your changes to the data. The view isolates sorting and filtering, not cell edits. Changing a name, amount, or status in a shared cell changes the workbook data for everyone with access.
  • Filtering an incomplete range. If the header row is missing, blank, or separated from the data by empty rows or columns, Excel may not recognize the full list. Convert the range to a table or select a cell in a clean, contiguous range before turning on filters.
  • Assuming a filter is a privacy feature. Sheet Views do not restrict access to rows or protect confidential information. Other workbook users may be able to create their own views or inspect the underlying records. Use appropriate file permissions or a separate workbook for sensitive data.
  • Leaving the view temporary. A temporary view may not be available the next time you open the workbook. Use the keep or save control when offered, and give a saved view a descriptive name.
  • Confusing hidden rows with deleted rows. A filter hides rows that do not meet the criteria; it does not remove them. Clear the filter to display the full list again before drawing conclusions about totals or missing records.

Tips

  • Use a formatted Excel table for growing lists. Select a cell in the data and choose Insert > Table, making sure My table has headers is selected if appropriate. Tables provide filter arrows and generally expand when you add rows directly beneath them, reducing the chance that new records are left outside the filter range.
  • Give views names that describe the criteria. A saved name such as Pending orders, West region, or Due this month tells you what to expect when you reopen it. Avoid a name that implies the view is private; Sheet Views are for independent work, not access control.
  • Apply filters one column at a time. This makes it easier to see which condition removed a row from the results. If the result is unexpectedly empty, clear the most recent filter first and check whether its values match the data exactly.
  • Use clear, consistent column headings. Unique headings such as Order date and Delivery date are easier to filter than repeated or blank headings. Avoid blank rows inside a list, because they can make the data range harder for Excel to identify.
  • Coordinate with collaborators. Tell coworkers when you are using a personal Sheet View if they are also working in the same worksheet. Their own views can differ, but cell edits remain shared and simultaneous edits may still affect the data everyone sees.
  • Clear criteria without abandoning the view. Open a filtered column’s drop-down and choose the clear-filter option, or use Data > Clear to clear filters from the current worksheet view. The exact result depends on which view is active, so confirm that you are in your Sheet View before clearing criteria.

Troubleshooting

I cannot find Sheet View. First check that you have opened the file in Excel for Microsoft 365 or Excel for the web and that it is saved to OneDrive or SharePoint. Older Excel versions, some file types, and locally stored copies may not show the same controls. Update or switch to a supported version, sign in to the account with access to the workbook, and reopen the cloud file. If the option is still missing, ask the workbook owner or Microsoft 365 administrator whether your account or organization’s setup limits the feature.

My filter changed what another person sees. You may have applied the filter in the normal worksheet view rather than a Sheet View. Undo the change promptly if it is still the latest action, or clear the filter and let collaborators know what happened. Then choose View > Sheet View > New and reapply your criteria. Do not assume that opening a shared file automatically puts you in an isolated view.

The filter arrow is missing or the wrong rows are included. Click inside the list and inspect its boundaries. Make sure there is one header row, no blank row splitting the records, and no merged cells in the header area. For a regular range, try selecting a cell in the data and using Data > Filter again. If needed, turn the filter off, select the complete range including its headers, and turn it back on. A table can make the intended data boundaries clearer.

The results are empty or do not match what I expected. Check for extra spaces, spelling differences, inconsistent date formats, or numbers stored as text. In the filter menu, confirm which values are checked and whether a second column has another active condition. Clear one criterion at a time rather than resetting everything immediately; this helps identify which selection is excluding the records.

I cannot find my saved view after reopening the file. Make sure you selected the option to keep or save the view, and that the workbook finished saving to OneDrive or SharePoint. Reopen View > Sheet View and check the list of available views. If you used a temporary view, it may not have been retained. Also confirm that you reopened the same workbook, not a downloaded copy or a duplicate with a similar name.

A coworker still sees my cell change. That is expected: Sheet Views separate filters and sorts, not edits to the shared records. If you need to test a change without altering the shared data, make a separate copy of the workbook or use an approved test file. Do not rely on a personal filter to conceal an edit.

Frequently Asked Questions

Can I filter a shared Excel file without affecting coworkers?
Yes. Create or select a Sheet View before applying the filter. Each person can then work with a different filtered or sorted view, while edits to the shared cell contents remain visible to collaborators.

Does Sheet View work if the workbook is saved on my computer?
For shared collaboration, use a workbook saved to OneDrive or SharePoint and a supported, current Excel version. A local copy or an older version may not provide Sheet View controls, and it will not be the same live shared workbook.

Can other people see or use my Sheet View?
Sheet Views are saved in the workbook and are not a security boundary. Other people may be able to see or select saved views, depending on the workbook and Excel interface. Do not use a view to hide sensitive rows from people who have access to the file.

Will my personal filter still be there when I reopen Excel?
It will be available if you kept or saved the Sheet View and the workbook saved successfully. Temporary views may not persist. Reopen the Sheet View menu and select the named view to restore its criteria.

Can I sort in a Sheet View as well as filter?
Yes. Sort using the column drop-down or the sorting controls while the Sheet View is active. The sort is part of the view, so it does not rearrange the worksheet for other collaborators in the same way a normal shared-view sort can.

What if I only want to filter one worksheet?
Create the Sheet View while that worksheet is active. Sheet Views are associated with individual worksheets, so switch to the relevant tab before creating or selecting the view. Filtering another worksheet requires setting up its view separately.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.