How to: Print Titles on a Worksheet
This example demonstrates how to print titles (row and column headings) on every page. To do this, use the following members of the WorksheetPrintTitleOptions object, which can be accessed using the WorksheetPrintOptions.PrintTitles property.
Members | Description |
---|---|
Repeat specific rows at the top of every printed page. | |
Repeat specific columns on the left side of every printed page. |
// Access an object that contains print options.
WorksheetPrintOptions printOptions = worksheet.PrintOptions;
// Print the first column and the first row on every page.
printOptions.PrintTitles.SetColumns(0, 0);
printOptions.PrintTitles.SetRows(0, 0);
To remove print titles from a specific worksheet, use the WorksheetPrintTitleOptions.Clear method.
See Also