Chart Page Break Title For Free

Right-click the table, and then click Table Properties. In the "Table Properties" dialog box, click the Row tab. In the "Options" group, make sure Repeat as header row at the top of each page is checked. Uncheck the box next to Allow row to break across pages.

Insert a line break in Excel by pressing Alt + Enter.

When you insert a manual page break (Ctrl+Enter) in a table, you split the table, and the empty paragraph is the result. To create a page break without splitting the table (which also allows your heading row(s) to repeat), apply the "Page break before" property to the row you want to appear on a new page.

Repeat table header on subsequent pagesIn the table, right-click in the row that you want to repeat, and then click Table Properties.In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of each page check box.Select OK.

Split a tablePut your cursor on the row that you want as the first row of your second table. In the example table, it's on the third row.On the LAYOUT tab, in the Merge group, click Split Table. The table splits into two tables.

To create a page break without splitting the table (which also allows your heading row(s) to repeat), apply the "Page break before" property to the row you want to appear on a new page. To do this, select the row, go to Format Paragraph, select the Line and Page Breaks tab, and check the box for "Page break before."

Note:Click the Page Layout tab > In the "Page Setup" group, click Print Titles.Under the Sheet tab, in the "Rows to repeat at top" field, click the spreadsheet icon.Click and select the row you wish to appear at the top of every page.Press the Enter key, then click OK.More items...