Excel® 2013 On Demand

Creating Custom Views

A view is a set of display and print settings that you can name and apply to a workbook. In Excel, you can create multiple custom views—such as one for developing a worksheet and another for entering data—in the same workbook without having to save separate copies. If you include print settings in a view, the view includes the defined print area. If the sheet has no defined print area, the view displays the entire worksheet. If one or more worksheets contain an Excel list, the Custom Views command is disabled for the entire workbook.

Create a Custom View

Set up the workbook to appear the way you want to view and print it. ...