Sheet Views in Microsoft Excel

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.

Excel Ribbon Menu with View tab highlighted

Select the New button adjacent to the Sheet View drop-down menu.

New Sheet View option highlighted

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.

Sheet View menu with Keep option highlighted.

If you select Exit, a dialog box will allow you to rename the view in order to keep it or to discard the view.

Do you want to keep your view dialog box? (Excel Online)

View management

Select the Options button to manage your views.

The Sheet View Options button

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.

Sheet View Options dialog box

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

Details

Article ID: 140466
Created
Mon 7/25/22 5:11 PM
Modified
Tue 7/26/22 11:06 AM