- Change the settings that you want to save in the view.
- On the View menu, click Custom Views.
- Click Add.
- In the Name box, type a name for the view.
Make sure to include the active sheet name in the name of a view to make it easier to identify. When you display a view, Microsoft Excel switches to the sheet that was active when you created the view. Excel lists all views in the workbook in the Custom Views dialog box.
- Under Include in view, select the options you want.
Delete a custom view- On the View menu, click Custom Views.
- In the Views box, click the name of the view you want, and then click Delete.