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.

[Visual Basic]
Property PrintTitleRows As String
[C#]
string PrintTitleRows { get; set; }
[C++]
__property String* get_PrintTitleRows();
__property void set_PrintTitleRows(String* );
[JScript]
function get PrintTitleRows() : String
function set PrintTitleRows(String);

Remarks

Set this property to the empty string to turn off title rows.

Example

This example defines row two as the title row, and it defines columns one through two as the title columns.

[C#]
book.Worksheets[1].PageSetup.PrintTitleRows = "$2:$2";
book.Worksheets[1].PageSetup.PrintTitleColumns = "$A:$B";

[Visual Basic]
book.Worksheets(1).PageSetup.PrintTitleRows = "$2:$2"
book.Worksheets(1).PageSetup.PrintTitleColumns = "$A:$B"

[C++]
book->Worksheets->Item[1]->PageSetup->PrintTitleRows = S"$2:$2";
book->Worksheets->Item[1]->PageSetup->PrintTitleColumns = S"$A:$B";

See Also

IPageSetup Interface | NativeExcel Namespace | PageSetup Property | PrintTitleColumns Property | SetPrintTitleRows Method | PrintTitleRowsDefined Property

---