Microsoft Office Tutorials and References
In Depth Information
Creating Custom Views
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 cop-
ies. 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
Create a Custom View
Set up the workbook to appear the way you want to view and print it.
Click the View tab.
Click the Custom Views button.
Click Add .
Type a name for the custom view.
To make it easier to identify, use the sheet name in the view name.
Select or clear the Print settings check box and the Hidden rows, columns
and filter settings check box.
Click OK .
Search JabSto ::

Custom Search