Skip to main content
A newer version of this page is available. .

XlPageSetup Properties

Represents the object that specifies page formatting options.
Name Description
AutomaticFirstPageNumber Gets or sets a value indicating whether the first page number should be selected automatically.
BlackAndWhite Gets or sets whether to print the worksheet in black and white or in color.
CommentsPrintMode Gets or sets how comments contained in a worksheet are printed.
Copies Gets or sets the number of worksheet copies to print.
Draft Gets or sets a value indicating whether the worksheet should be printed without graphics and graphic elements (such as gridlines).
ErrorsPrintMode Gets or sets how errors contained in worksheet cells are printed.
FirstPageNumber Gets or sets the number from which pagination starts on the current worksheet.
FitToHeight Gets or sets the number of pages by height in which the worksheet should fit when printed.
FitToPage Gets or sets a value indicating whether the worksheet content should be scaled to fit on a specific number of pages.
FitToWidth Gets or sets the number of pages wide the worksheet should fit on when printed.
HorizontalDpi Gets or sets the horizontal printer resolution, in dots per inch.
PageOrientation Gets or sets the page orientation applied when a worksheet is being printed.
PagePrintOrder Gets or sets the order in which worksheet pages are numbered and printed.
PaperKind Gets or sets a value that specifies the paper size used when a worksheet is being printed.
Scale Gets or sets the percentage by which to scale the worksheet content.
UsePrinterDefaults Gets or sets a value indicating whether to use the default page settings specified by the printer.
VerticalDpi Gets or sets the vertical printer resolution, in dots per inch.
See Also