Search notes:
Excel Object Model: Windows.view
A window's view property can be set to one of the members of the
xlWindowView
enumeration:
-
xlNormalView
-
xlPageLayoutView
(which additionally shows page header)
-
xlPageBreakPreview
In addition, it is possible to create a custom view (property customViews
).
In the following image, the
.view
property is set to
xlPageLayoutView
:
In order to view header and footer with Excel's menu, the tab Insert must be chosen, then Text -> Header & Footer be selected.