PageSetup Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

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

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

BlackAndWhite

True if elements of the document will be printed in black and white. Read/write Boolean.

BottomMargin

Returns or sets the size of the bottom margin, in points. Read/write Double.

CenterFooter

Center aligns the footer information in the PageSetup object. Read/write String.

CenterFooterPicture

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

CenterHeader

Center aligns the header information in the PageSetup object. Read/write String.

CenterHeaderPicture

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

CenterHorizontally

True if the sheet is centered horizontally on the page when it's printed. Read/write Boolean.

CenterVertically

True if the sheet is centered vertically on the page when it's printed. Read/write Boolean.

Creator

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

DifferentFirstPageHeaderFooter

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

Draft

True if the sheet will be printed without graphics. Read/write Boolean.

EvenPage

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

FirstPage

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

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. Read/write Long.

FitToPagesTall

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

FitToPagesWide

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

FooterMargin

Returns or sets the distance from the bottom of the page to the footer, in points. Read/write Double.

HeaderMargin

Returns or sets the distance from the top of the page to the header, in points. Read/write Double.

LeftFooter

Returns or sets the alignment of text on the left footer of a workbook or section.

LeftFooterPicture

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

LeftHeader

Returns or sets the alignment of text on the left header of a workbook or section.

LeftHeaderPicture

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

LeftMargin

Returns or sets the size of the left margin, in points. Read/write Double.

OddAndEvenPagesHeaderFooter

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

Order

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

Orientation

Returns or sets a XlPageOrientation value that represents the portrait or landscape printing mode.

Pages

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

PaperSize

Returns or sets the size of the paper. Read/write XlPaperSize.

Parent

Returns the parent object for the specified object. Read-only.

PrintArea

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

PrintComments

Returns or sets the way comments are printed with the sheet. Read/write XlPrintLocation.

PrintErrors

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

PrintGridlines

True if cell gridlines are printed on the page. Applies only to worksheets. Read/write Boolean.

PrintHeadings

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

PrintNotes

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

PrintQuality

Returns or sets the print quality. Read/write Variant.

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. Read/write String.

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. Read/write String.

RightFooter

Returns or sets the distance (in points) between the right edge of the page and the right boundary of the footer. Read/write String.

RightFooterPicture

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

RightHeader

Returns or sets the right part of the header. Read/write String.

RightHeaderPicture

Specifies the graphic image that should be displayed in the right header. Read-only.

RightMargin

Returns or sets the size of the right margin, in points. Read/write Double.

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

Returns or sets the size of the top margin, in points. Read/write Double.

Zoom

Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.

Show: