Create a Personal Sheet View in an Excel Online Shared Workbook
Question details
The user wants to create a reusable view in a shared Excel workbook so their sorting and filtering do not change what other collaborators see.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- Multiple people use the same worksheet, and one user needs a separate filter and sort configuration.
- Observed behavior
- Sheet Views can isolate sorting and filtering from the default view, but a named view is not private and may be available to other people with workbook access.
Open the shared workbook in Excel for the web and confirm that you have permission to edit it. Sheet Views require a supported workbook stored in OneDrive or SharePoint; check the View tab for the Sheet View controls.
Create and save a Sheet View for independent sorting and filtering
Use a named Sheet View to keep your filter and sort choices separate from the shared worksheet's default view.
A Sheet View provides a separate way to display the same worksheet data. It is not a private copy: other users with workbook access may see and select saved views, and cell edits still affect the shared workbook.
Open the workbook in Excel for the web, then click the worksheet tab containing the data you want to sort or filter.
On the ribbon, select View > Sheet View > New. Confirm that a temporary Sheet View is active before changing the filters or sort order.
Use the column-header filter arrows to select the values you want to display or choose a sort order. If filter arrows are not visible, select the data range and choose Data > Filter.
In the Sheet View controls on the View tab, choose Keep to save the temporary view. Use the view name field to give it a descriptive name, such as 'Open Orders by Date.'
Select View and use the Sheet View selector to choose your saved view whenever you need it. Choose Default to return to the shared default view, but avoid sorting or filtering there if you do not want to affect collaborators using it.
Use WPS Spreadsheet to Analyze a Separate Copy of Your Workbook
WPS Office is a free, lightweight alternative with familiar spreadsheet controls and Excel format compatibility for easy migration. If you do not need live collaboration, open a separate downloaded copy in WPS Spreadsheet and sort or filter it independently. This does not create or manage Excel Online Sheet Views.
Frequently Asked Questions
Can other people see my saved Sheet View?
Yes. A saved Sheet View is part of the workbook and may be visible to other people with workbook access. Naming a view after yourself does not make it private or restrict access to the underlying data.
Will editing cells in my Sheet View change the shared workbook?
Yes. Sheet Views isolate sorting and filtering, not cell edits. Changing a value or formula changes the workbook for other users, regardless of which view is active.
How do I switch back to the normal worksheet view?
Go to View and select Default in the Sheet View selector. To restore your saved filters and sorting later, select your named view from the same selector.
Why can't I create a Sheet View?
Check that you are opening a supported workbook from OneDrive or SharePoint in Excel for the web and that you have editing permission. Then look under View > Sheet View. If the controls remain unavailable, ask the workbook owner to check the file's format, storage location, and your access.
Can I format the worksheet independently in a Sheet View?
Do not rely on Sheet Views to isolate formatting. Their purpose is to provide separate sort and filter settings. If you need independent formatting or analysis, create a separate workbook copy instead.
