Excel Online Filter: See Just Your Rows in a Sheet View

Formulas & functions · Updated November 19, 2026

Yes. In Excel for the web, use a Sheet View to filter a shared worksheet so you see only the rows you need without changing the filter or sort other collaborators see. Open View > Sheet View > New, then apply a filter to the column you want; this changes your view, not who can access the underlying data.

What a Sheet View does

A normal filter hides rows that do not match your chosen conditions. In a shared workbook, applying that filter in the default worksheet view can change what other people see, too. Sheet View gives you a separate view of the same worksheet, so you can filter or sort the records for your own task while collaborators continue working with their views.

For example, imagine a team workbook with columns for Task, Owner, Status, and Due date. You can filter Owner to your name and see only your assignments. A colleague can independently filter Owner to their name. Neither filter deletes rows or creates a separate copy of the workbook; all the records remain in the shared sheet.

Sheet Views are useful for collaboration, but they are not a privacy feature. They change how worksheet data is displayed, not who is allowed to read it. Anyone with permission to open the workbook may still be able to remove a filter, switch views, or inspect the underlying records.

Create a personal view in Excel for the web

  1. Open the shared workbook in Excel for the web. Sheet Views are intended for collaborative workbooks saved in OneDrive or SharePoint; if a file is only on your computer, first save or move it to a supported cloud location and share it as needed.
  2. Open the worksheet you want to filter. Sheet Views apply to a worksheet, so create or select the view on the sheet containing the relevant records.
  3. Select View > Sheet View > New. Excel opens a new sheet view. The exact presentation of the controls can vary slightly with the web interface.
  4. With the new view active, turn on filtering if needed. Use Data > Filter, or use the filter arrows already displayed in a formatted Excel table.
  5. Open the arrow in the column you want to filter. Clear Select All, select your name or other criteria, and apply the filter. You should now see matching rows only in your view.

If Excel labels the view as temporary, use the available Keep or save option if you want it to remain in the workbook’s Sheet View list. When you finish, use the Sheet View controls to exit the view or return to the default view. Check the active view indicator before making further filters: a filter applied after you leave your Sheet View may affect the default view instead.

Filter for your name, tasks, or other criteria

For a straightforward “show just mine” filter, use the column that identifies the owner, assignee, or person responsible. In its filter menu, select only your name. If names are entered inconsistently—for example, some rows say Alex Lee and others say A. Lee—the filter treats those as different text values. You may need to select every version that represents you or ask the workbook owner to standardize the entries.

You can also narrow the results further. In the task example, select your name in Owner, then select In Progress in Status. The result shows your in-progress tasks rather than every task assigned to you. You can apply filters to multiple columns in the same view; each additional condition narrows the visible rows.

  • Text: choose one or more names, categories, or labels in the column menu.
  • Dates: select the relevant dates or use the date-filter options available for that column.
  • Numbers: filter for a range or a condition such as values above a threshold, when those options are offered.
  • Blanks: select blank or nonblank entries to find records that still need an owner or other information.

Filtering hides nonmatching rows from the current display; it does not remove them. To see the full list again, clear the filter in that column or return to the unfiltered view. Be cautious when copying visible results: depending on how you select and copy cells, it may be possible to include more than the rows currently shown.

Sort without disrupting coworkers

A Sheet View can be helpful when you want a different order as well as a different set of visible rows. For instance, you could display only your tasks and sort them by due date, putting the nearest deadline first. Sorting the shared default view can rearrange the rows for other collaborators, so create or activate your Sheet View before sorting.

Keep each record together when sorting. Use the sort command on a column within the data range or table, rather than selecting and sorting only one column’s cells. Sorting a single column independently can separate names from their matching tasks or dates. If Excel asks whether to expand the selection, choose the option that includes the related data.

How Sheet Views affect collaboration

Sheet Views separate certain display choices—especially filters and sorts—from the default view. They do not create independent versions of the data. If you edit a task’s status while looking at your filtered view, you are editing the shared cell. Other authorized users can see that change, even if their filters mean the row is not currently visible to them.

Saved views are associated with the workbook and worksheet rather than being secret, personal files. Collaborators may be able to see or use available views, depending on their access and the controls in their Excel version. Give a view a clear name if the workbook offers a rename option, such as My open tasks, so its purpose is understandable. Do not put confidential information in a view name or assume that a filter hides sensitive rows securely.

Sheet Views also do not prevent someone from editing, deleting, or moving shared data. Workbook permissions and, where appropriate, worksheet protection are separate controls. Use the organization’s access and sharing settings when the goal is to restrict who can see or change information.

When to use a Sheet View instead of a regular filter

Use a Sheet View when several people work in the same worksheet and each person needs a different filter or sort. It is also useful when you want to keep a named view for a recurring task, such as reviewing overdue items, while leaving the default display unchanged.

A regular filter may be enough when you are working alone, or when everyone using the workbook agrees on one shared display. If a table already has filter arrows, you can use those for the default view, but remember that the result may be visible to other collaborators. For a one-off personal analysis that should not affect the worksheet layout, consider making a copy of the data or using a separate worksheet, subject to your team’s rules for handling the workbook.

Common problems and fixes

  • Sheet View is unavailable: Confirm that you opened the workbook in Excel for the web and that it is stored in OneDrive or SharePoint. A local file, an unsupported format, or a restricted workbook state may limit collaboration features. If necessary, save a compatible workbook copy to the cloud and reopen it.
  • The filter arrow is missing: Select the data range and choose Data > Filter, or format the records as a table so the header row includes filter controls. Make sure the range has a clear header row and no completely blank row splitting the records into separate blocks.
  • Rows other than yours still appear: Check that the correct column is filtered and that every spelling or variant of your name has been considered. Also check other active column filters, which may be narrowing the results unexpectedly.
  • Your colleague sees your sort or filter: Check whether you are in a Sheet View or the default view before applying the change. If you changed the default view, return to it and restore the intended display; then create a Sheet View for your own filtering.
  • You cannot find your view later: It may have been temporary and not saved, or you may be on a different worksheet. Reopen the Sheet View menu on the original sheet and check the available views.

Frequently Asked Questions

Can I filter a shared Excel sheet to show only my rows?
Yes. Create a Sheet View, then filter the owner or assignee column to your name. This isolates your filter and sort from the default view, while keeping the shared data intact.

Will filtering my rows hide them from everyone else?
No. A filter hides nonmatching rows from a view; it does not restrict access. People with workbook access may still see the other records by changing or clearing filters or selecting another view.

Does Excel Online have Sheet View?
Yes. In Excel for the web, look under View > Sheet View. Sheet Views are designed for working with a shared workbook, and the available controls can differ slightly from the desktop interface.

Can two people filter the same sheet differently?
Yes. Each person can use a separate Sheet View and choose different filters or sorts. Remember that edits to the cells themselves are still edits to the same shared worksheet.

Why did my filter affect someone else?
You may have filtered the default worksheet view rather than creating or activating a Sheet View first. Check the current view in the Sheet View controls, then apply the filter again from your own view.

Bottom line

To see just your records in a shared Excel Online workbook, create a Sheet View first and then filter the owner column to your name. It is the right tool for keeping coworkers’ display undisturbed, but it is not a way to conceal rows or limit data access. If the records must be private, use workbook permissions or a separately managed file instead.

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.