Have you ever collaborated with someone else in a worksheet, looking at a large data set, and suddenly the table shrinks and you’re unable to finish your work? It's pretty disruptive, isn't it?
Sheet Views is an innovative way of letting you create customized views in an Excel worksheet without being disrupted by others. For instance, you can set up a filter to display only the records that are important to you, without being affected by others sorting and filtering in the document. You can even set up multiple Sheet Views on the same worksheet. Any cell-level edits you make will automatically be saved with the workbook regardless of which view you’re in.
-
Select the worksheet where you want the Sheet View, then click to View > Sheet View > New.
-
Apply the sort/filter that you want. Excel automatically names your new view Temporary View to indicate the Sheet View isn't saved yet.
-
To save it, click Temporary View in the Sheet View menu, type the new sheet view name, and then press Enter.
Keep in the mind the following:
-
Once you create a Sheet View, it's available on all Excel platforms: Excel for Desktop and Mac, Excel for the web, and Excel on a mobile device.
-
If other people are working on the file, you can sort or filter, and Excel asks if you want to apply that sort or filter for just you, or everyone. This is another entry point for Sheet Views.
-
When you're ready to display a particular view, you can select it from the Sheet View menu.
-
The Sheet View menu only displays views for the active worksheet.
-
When a Sheet View is applied, an eye symbol appears next to the worksheet tab name. Hovering over the eye will display the active Sheet View's name.
-
When you first create a new Sheet View, Excel will preserve your initial view and display it in the Sheet View switcher as Default. Selecting the default option will reset your view to the main view of the document.
-
To close a Sheet View and return to the default view, select View > Sheet View > Exit.
-
To switch between views, select View > Sheet View, and then select your view from the Sheet View menu.
-
If you decide that you no longer want a particular Sheet View, select View > Options, select the view in question, and then press Delete.
-
Select View > Options.
-
In the Sheet View options dialog box, select Rename or Duplicate existing views.
-
To activate a view, double-click the sheet name in the list.
It's more useful when everyone in a document uses Sheet View so that when coauthoring, no one is being impacted by each other's sorts and filters. If you are not in Sheet View, you will be impacted by others who sort and filter. To reduce this impact, we will sometimes opt you into a Sheet View so that you are unaffected by sorts and filters from others.
While using a Sheet View, you can hide, or display columns and rows just as you would normally. This lets you see only the columns and rows you care about without changing the view for others.
Additionally, we will not opt you into a Sheet View when you hide, or display columns and rows in the document. You must enter a Sheet View and perform these actions there just as you would normally. If you hide or display columns or rows in default view, it persists across all Sheet Views on Excel for Desktop and Mac, and Excel for the web. For Excel on a mobile device, then it opts-in to Sheet View instead.
Why do my Sheet View options appear grayed out? You can only use Sheet Views in a document that is stored in a SharePoint or OneDrive location. Sheet Views are supported in Excel for Microsoft 365 and Excel 2021. If you save a local copy of a file that contains sheet Views, the Sheet Views will be unavailable.
Is a Sheet View private, and only for me? No, other people who share the workbook can see views you create if they go to the View tab and look at the Sheet View menu in the Sheet Views group.
Can I make different Sheet Views? You can create up to 256 Sheet Views, but you probably don't want to get overly complicated.
