WorksheetHeaderFooterOptions Properties

Allows you to specify headers and footers for a worksheet or chart sheet.

Name	Description
AlignWithMargins	Gets or sets whether the sides of a header or a footer should be aligned with page margins.
DifferentFirst	Gets or sets whether the first page of the document contains a header and footer that is different from headers and footers on other pages.
DifferentOddEven	Gets or sets whether headers and footers on odd pages should be different from those on even pages.
EvenFooter	Provides access to the footer for even pages.
EvenHeader	Provides access to the header for even pages.
FirstFooter	Provides access to the footer for the first page.
FirstHeader	Provides access to the header for the first page.
OddFooter	Provides access to the footer for odd pages.
OddHeader	Provides access to the header for odd pages.
ScaleWithDoc	Specifies whether the header and footer should scale when you use the “Shrink to Fit” feature in the document.