How to Use the Page Break Preview in Excel 2013

The Page Break Preview button is the third one in the cluster to the left of the Zoom slider. Alternatively, you can click View→Page Break Preview on the Ribbon or press Alt+WI.

This takes you into a Page Break Preview worksheet view that shows your worksheet data at a reduced magnification with the page numbers displayed in large light type and the page breaks shown by heavy lines between the columns and rows of the worksheet.