When preparing an Excel document for printing, it's important to ensure that your data and text display correctly on the pages. One of the more useful formatting elements is a manual page break ...

Q: I can’t figure out why the “Page break between groups” option in the attached Excel 2013 workbook doesn’t work; this page break functionality seems to work fine in all of my other workbooks, just ...

If you select a new paper size, Excel automatically adjusts the page break lines on the worksheet. Click the "Orientation" button on the ribbon to check the printing orientation.

To set print titles, go to the "Page Layout" tab, click on "Print Titles," and in the "Rows to repeat at top" or "Columns to repeat at left" box, select the row or column you want to be repeated on ...