Skip to main content
Row

WorksheetHeaderFooterOptions Members

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

Properties

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.
See Also