In the current version of Excel for Office 365, a manually added page break shows as a solid horizontal line, while automatically generated page breaks show as dotted lines.

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 ...

1] On Windows and Web. Double-click on the cell where you want to add the line break. Go to where you want the line break and press Alt + Enter.; This will enter a new line of text in the Excel cell.

Use Forced Line Breaks. When you want to enter hard carriage returns rather than letting Excel wrap your text, force a line break instead. Press alt-Enter at the end of each line.

Go to the Excel menu and then choose the Insert Page Break option. You will then see a vertical line on your worksheet which indicates where exactly the page will break. If you want to make a ...