Skip to main content

How to: Insert Page Breaks in a Worksheet

A worksheet’s page breaks are stored in two PageBreaksCollection collections:

Use the PageBreaksCollection.Add method to insert page breaks.

// Insert a page break after the "F" column.
// Insert a page break below the 14th row.

The image below shows the result (the workbook is opened in Microsoft® Excel®).


Delete a Page Break

Use the following API to remove page breaks from a worksheet: