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.