Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Create, apply, or delete a custom view

You can use a custom view to save specific display settings (such as hidden rows and columns, cell selections, filter settings, and window settings) and print settings (such as page settings, margins, headers and footers, and sheet settings) for a worksheet so that you can quickly apply these settings to that worksheet when needed. You can also include a specific print area in a custom view.

You can create multiple custom views per worksheet, but you can only apply a custom view to the worksheet that was active when you created the custom view. If you no longer need a custom view, you can delete it.

Create a custom view

  1. On a worksheet, change the display and print settings that you want to save in a custom view.

  2. Go to ViewWorkbook ViewsCustom Views > Add.

  3. In the Name box, type a name for the view.

    Tip: To make a view easier to identify, you can include the name of the active worksheet in the name of a view.

  4. Under Include in view, select the check boxes of the settings that you want to include. All the views that you add to the workbook appear under Views in the Custom Views dialog box. When you select a view in the list, and then click Show, the worksheet that was active when you created the view will be displayed.

Important: If any worksheet in the workbook contains an Excel table, then Custom Views will not be available anywhere in the workbook.

Apply a custom view

  1. Go to ViewWorkbook ViewsCustom Views.

  2. In the Views box, click the name of the view that you want to apply, and then click Show.

Note: If your view was created on another worksheet, then that worksheet will be automatically displayed.

Delete a custom view

  1. Go to ViewWorkbook ViewsCustom Views.

  2. In the Views box, click the name of the view that you want to delete, and then click Delete.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×