Page History

{description}
{excerpt}The [PageSetup|PageSetup] class represents the page layout properties of a printed worksheet.{excerpt}
{signature:C#}
 public class PageSetup
{signature}{signature:vb.net}
Public Class PageSetup
{signature}
{remarks}To return a {{PageSetup}} object, use [Worksheet.PageSetup|Worksheet.PageSetup].

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          PageSetup ps = wb.Worksheets[0].PageSetup;
        {code}
{code:vbnet|title=vb.net}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ps As PageSetup = wb.Worksheets(0).PageSetup
        {code}

{example}
{properties}
||Name||Description||
|[BottomMargin|PageSetup.BottomMargin]|{excerpt-include:PageSetup.BottomMargin|nopanel=true}|
|[CenterFooter|PageSetup.CenterFooter]|{excerpt-include:PageSetup.CenterFooter|nopanel=true}|
|[CenterHeader|PageSetup.CenterHeader]|{excerpt-include:PageSetup.CenterHeader|nopanel=true}|
|[CenterHorizontally|PageSetup.CenterHorizontally]|{excerpt-include:PageSetup.CenterHorizontally|nopanel=true}|
|[CenterVertically|PageSetup.CenterVertically]|{excerpt-include:PageSetup.CenterVertically|nopanel=true}|
|[FirstPageNumber|PageSetup.FirstPageNumber]|{excerpt-include:PageSetup.FirstPageNumber|nopanel=true}|
|[FirstPageNumberAuto|PageSetup.FirstPageNumberAuto]|{excerpt-include:PageSetup.FirstPageNumberAuto|nopanel=true}|
|[FitToPagesTall|PageSetup.FitToPagesTall]|{excerpt-include:PageSetup.FitToPagesTall|nopanel=true}|
|[FitToPagesWide|PageSetup.FitToPagesWide]|{excerpt-include:PageSetup.FitToPagesWide|nopanel=true}|
|[FooterMargin|PageSetup.FooterMargin]|{excerpt-include:PageSetup.FooterMargin|nopanel=true}|
|[HeaderMargin|PageSetup.HeaderMargin]|{excerpt-include:PageSetup.HeaderMargin|nopanel=true}|
|[LeftFooter|PageSetup.LeftFooter]|{excerpt-include:PageSetup.LeftFooter|nopanel=true}|
|[LeftHeader|PageSetup.LeftHeader]|{excerpt-include:PageSetup.LeftHeader|nopanel=true}|
|[LeftMargin|PageSetup.LeftMargin]|{excerpt-include:PageSetup.LeftMargin|nopanel=true}|
|[Orientation|PageSetup.Orientation]|{excerpt-include:PageSetup.Orientation|nopanel=true}|
|[PaperSize|PageSetup.PaperSize]|{excerpt-include:PageSetup.PaperSize|nopanel=true}|
|[PrintArea|PageSetup.PrintArea]|{excerpt-include:PageSetup.PrintArea|nopanel=true}|
|[PrintAsDraft|PageSetup.PrintAsDraft]|{excerpt-include:PageSetup.PrintAsDraft|nopanel=true}|
|[PrintCellErrorsAs|PageSetup.PrintCellErrorsAs]|{excerpt-include:PageSetup.PrintCellErrorsAs|nopanel=true}|
|[PrintComments|PageSetup.PrintComments]|{excerpt-include:PageSetup.PrintComments|nopanel=true}|
|[PrintCommentsAtEnd|PageSetup.PrintCommentsAtEnd]|{excerpt-include:PageSetup.PrintCommentsAtEnd|nopanel=true}|
|[PrintGridlines|PageSetup.PrintGridlines]|{excerpt-include:PageSetup.PrintGridlines|nopanel=true}|
|[PrintHeadings|PageSetup.PrintHeadings]|{excerpt-include:PageSetup.PrintHeadings|nopanel=true}|
|[PrintInBlackAndWhite|PageSetup.PrintInBlackAndWhite]|{excerpt-include:PageSetup.PrintInBlackAndWhite|nopanel=true}|
|[PrintOrder|PageSetup.PrintOrder]|{excerpt-include:PageSetup.PrintOrder|nopanel=true}|
|[PrintTitles|PageSetup.PrintTitles]|{excerpt-include:PageSetup.PrintTitles|nopanel=true}|
|[RightFooter|PageSetup.RightFooter]|{excerpt-include:PageSetup.RightFooter|nopanel=true}|
|[RightHeader|PageSetup.RightHeader]|{excerpt-include:PageSetup.RightHeader|nopanel=true}|
|[RightMargin|PageSetup.RightMargin]|{excerpt-include:PageSetup.RightMargin|nopanel=true}|
|[TopMargin|PageSetup.TopMargin]|{excerpt-include:PageSetup.TopMargin|nopanel=true}|
|[UseZoom|PageSetup.UseZoom]|{excerpt-include:PageSetup.UseZoom|nopanel=true}|
|[Zoom|PageSetup.Zoom]|{excerpt-include:PageSetup.Zoom|nopanel=true}|
{methods}
||Name||Description||
|[GetFooter(HeaderFooterSection.Section)|PageSetup.GetFooter(HeaderFooterSection.Section)]|{excerpt-include:PageSetup.GetFooter(HeaderFooterSection.Section)|nopanel=true}|
|[GetHeader(HeaderFooterSection.Section)|PageSetup.GetHeader(HeaderFooterSection.Section)]|{excerpt-include:PageSetup.GetHeader(HeaderFooterSection.Section)|nopanel=true}|
|[SetPrintTitleColumns(Int32, Int32)|PageSetup.SetPrintTitleColumns(Int32, Int32)]|{excerpt-include:PageSetup.SetPrintTitleColumns(Int32, Int32)|nopanel=true}|
|[SetPrintTitleRows(Int32, Int32)|PageSetup.SetPrintTitleRows(Int32, Int32)]|{excerpt-include:PageSetup.SetPrintTitleRows(Int32, Int32)|nopanel=true}|

{classes}
||Name||Description||
|[CellErrorsAs|PageSetup.CellErrorsAs]|{excerpt-include:PageSetup.CellErrorsAs|nopanel=true}|
|[PageOrientation|PageSetup.PageOrientation]|{excerpt-include:PageSetup.PageOrientation|nopanel=true}|
|[PagePaperSize|PageSetup.PagePaperSize]|{excerpt-include:PageSetup.PagePaperSize|nopanel=true}|
|[PagePrintOrder|PageSetup.PagePrintOrder]|{excerpt-include:PageSetup.PagePrintOrder|nopanel=true}|