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. By inserting a page break, you can control exactly where one page ends and another begins, allowing you to keep related data together on the same page. You can also insert a manual line break when you have text that won't fit in the width of a cell. The line break forces your text to display on multiple lines within the cell.
Click the "View" tab and select either "Normal" or "Page Break Preview" from the ribbon.
Click the row number below where you want to insert a page break, so that you select the entire row. To insert a vertical page break, click the column letter to the right of where you want the break.
Click the "Page Layout" tab, and then click "Breaks" on the Page Setup section of the ribbon. Select "Insert Page Break" from the options.
Double-click the cell that contains your text.
Position your cursor at the point in the text where you want to force a new line.
Press "Alt-Enter" on the keyboard to create the manual line break.