Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.
worksheet.VerticalPageBreaks.Add(6);
// Insert a page break below the 14th row.
worksheet.HorizontalPageBreaks.Add(14);

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

Spreadsheet_PageBreaks

#Delete a Page Break

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