Overview
This article is intended to guide Excel users through the process of creating sheet views. Sheet views allow for you to sort and filter the data in collaborative workbooks without affecting the view for your colleagues.
Note: Sheet views work for Excel files that are stored in OneDrive or SharePoint.
Process
Go into an Excel workbook file and select the View tab from the ribbon menu.
Select the New button adjacent to the Sheet View drop-down menu.
This will create a temporary view. You can add filters, sort the data, and freeze panes (among other options) however you wish. If you decide that you like your view, select the Keep button. This will rename your temporary view, View1. You can rename it by selecting the Options button.
If you select Exit, a dialog box will allow you to rename the view in order to keep it or to discard the view.
View management
Select the Options button to manage your views.
You can rename the view you just created, you can duplicate an existing view, delete views you no longer need or switch to another view.
Considerations
- Sheet views that you create are visible for all who have access to the file by going to the View > Sheet View drop-down menu.
- There can be up to 256 sheet views per Excel workbook file.
- Upon closing the file, it will be reset to its Default view. If you saved your view, you can select it from the View > Sheet View drop-down menu.
Additional Resources