PageSetup PageSetup PageSetup Interface

Definition

Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

public interface class PageSetup
[System.Runtime.InteropServices.Guid("000208B4-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PageSetup
Public Interface PageSetup
Attributes

Remarks

Use the PageSetup property of a Worksheet or Chart object to return a PageSetup object.

Properties

AlignMarginsHeaderFooter AlignMarginsHeaderFooter AlignMarginsHeaderFooter

Returns True for Excel to align the header and the footer with the margins set in the page setup options. Read/write Boolean.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

BlackAndWhite BlackAndWhite BlackAndWhite

True if elements of the document will be printed in black and white.

BottomMargin BottomMargin BottomMargin

Returns or sets the size of the bottom margin in points.

CenterFooter CenterFooter CenterFooter

Returns or sets the center part of the footer.

CenterFooterPicture CenterFooterPicture CenterFooterPicture

Returns a Graphic object that represents the picture for the center section of the footer. Used to set attributes about the picture.

CenterHeader CenterHeader CenterHeader

Returns or sets the center part of the header.

CenterHeaderPicture CenterHeaderPicture CenterHeaderPicture

Returns a Graphic object that represents the picture for the center section of the header. Used to set attributes about the picture.

CenterHorizontally CenterHorizontally CenterHorizontally

True if the sheet is centered horizontally on the page when it's printed.

CenterVertically CenterVertically CenterVertically

True if the sheet is centered vertically on the page when it's printed.

ChartSize ChartSize ChartSize

Returns or sets the way a chart is scaled to fit on a page.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

DifferentFirstPageHeaderFooter DifferentFirstPageHeaderFooter DifferentFirstPageHeaderFooter

True if a different header or footer is used on the first page. Read/write Boolean.

Draft Draft Draft

True if the sheet will be printed without graphics.

EvenPage EvenPage EvenPage

Returns or sets the alignment of text on the even page of a workbook or section.

FirstPage FirstPage FirstPage

Returns or sets the alignment of text on the first page of a workbook or section.

FirstPageNumber FirstPageNumber FirstPageNumber

Returns or sets the first page number that will be used when this sheet is printed. If xlAutomatic, Microsoft Excel chooses the first page number. The default is xlAutomatic.

FitToPagesTall FitToPagesTall FitToPagesTall

Returns or sets the number of pages tall the worksheet will be scaled to when it's printed. Applies only to worksheets.

FitToPagesWide FitToPagesWide FitToPagesWide

Returns or sets the number of pages wide the worksheet will be scaled to when it's printed. Applies only to worksheets.

FooterMargin FooterMargin FooterMargin

Returns or sets the distance from the bottom of the page to the footer, in points.

HeaderMargin HeaderMargin HeaderMargin

Returns or sets the distance from the top of the page to the header, in points.

LeftFooter LeftFooter LeftFooter

Returns or sets the left part of the footer.

LeftFooterPicture LeftFooterPicture LeftFooterPicture

Returns a Graphic object that represents the picture for the left section of the footer. Used to set attributes about the picture.

LeftHeader LeftHeader LeftHeader

Returns or sets the left part of the header.

LeftHeaderPicture LeftHeaderPicture LeftHeaderPicture

Returns a Graphic object that represents the picture for the left section of the header. Used to set attributes about the picture.

LeftMargin LeftMargin LeftMargin

Returns or sets the size of the left margin in points.

OddAndEvenPagesHeaderFooter OddAndEvenPagesHeaderFooter OddAndEvenPagesHeaderFooter

True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages. Read/write Boolean.

Order Order Order

Returns or sets the order that Microsoft Excel uses to number pages when printing a large worksheet.

Orientation Orientation Orientation

Portrait or landscape printing mode.

Pages Pages Pages

Returns or sets the the count or item number of the pages in Pages collection.

PaperSize PaperSize PaperSize

Returns or sets the size of the paper.

Parent Parent Parent

Returns the parent object for the specified object.

PrintArea PrintArea PrintArea

Returns or sets the range to be printed, as a string using A1-style references in the language of the macro.

PrintComments PrintComments PrintComments

Returns or sets the way comments are printed with the sheet.

PrintErrors PrintErrors PrintErrors

Sets or returns an XlPrintErrors constant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet.

PrintGridlines PrintGridlines PrintGridlines

True if cell gridlines are printed on the page. Applies only to worksheets.

PrintHeadings PrintHeadings PrintHeadings

True if row and column headings are printed with this page. Applies only to worksheets.

PrintNotes PrintNotes PrintNotes

True if cell notes are printed as end notes with the sheet. Applies only to worksheets.

PrintQuality[Object] PrintQuality[Object] PrintQuality[Object]

Returns or sets the print quality.

PrintTitleColumns PrintTitleColumns PrintTitleColumns

Returns or sets the columns that contain the cells to be repeated on the left side of each page as a string in A1-style notation in the language of the macro.

PrintTitleRows PrintTitleRows PrintTitleRows

Returns or sets the rows that contain the cells to be repeated at the top of each page as a string in A1-style notation in the language of the macro.

RightFooter RightFooter RightFooter

Returns or sets the right part of the footer.

RightFooterPicture RightFooterPicture RightFooterPicture

Returns a Graphic object that represents the picture for the right section of the footer. Used to set attributes of the picture.

RightHeader RightHeader RightHeader

Returns or sets the right part of the header.

RightHeaderPicture RightHeaderPicture RightHeaderPicture

Returns a Graphic object that represents the picture for the right section of the header. Used to set attributes about the picture.

RightMargin RightMargin RightMargin

Returns or sets the size of the right margin in points.

ScaleWithDocHeaderFooter ScaleWithDocHeaderFooter ScaleWithDocHeaderFooter

Returns or sets if the header and footer should be scaled with the document when the size of the document changes. Read/write Boolean.

TopMargin TopMargin TopMargin

Returns or sets the size of the top margin in points.

Zoom Zoom Zoom

Returns or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets.

Applies to