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

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.

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.

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.

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

In Excel, Shift-End+Down Arrow ... Ctrl+End moves the cursor to the end of a document, which includes any additional line or page breaks, tabs, spaces, etc. In Excel, End has broader responsibilities.