Microsoft Excel 2013 automatically inserts page breaks into your worksheets based on its current settings, such as the margin, paper size and scale options. The Page Break Preview view helps you identify the page breaks for your current worksheet, and you can use the Insert Page Break command to manually insert page breaks. You must select the cell where you wish your new page to begin before you manually insert a page break. Page breaks affect how your worksheet separates pages for printing.
Open the Excel worksheet you wish to edit. Click the "View" tab and then select the "Page Break Preview" command in the Workbook Views group. Alternatively, click the Page Break Preview button, resembling a square with two rectangles inside, on the status bar below your worksheet. Click "OK" if the "Welcome to Page Break Preview" dialog box appears.
Video of the Day
Select one of the cells in the row below, or the column to the right, where you want to insert a page-break. For example, if you want to add a horizontal page break to your spreadsheet, select a cell in the row you wish to use as the first row of your new page.
Right-click the selected cell and then select "Insert Page Break." Alternatively, click the "Page Layout" tab, the "Breaks" drop-down button in the Page Setup group and then select "Insert Page Break." Your new page break is marked by the solid blue line. Repeat the process to add additional page breaks to your worksheet.
Click the "Normal" command in the Workbook Views of the View ribbon. Alternatively, click the "Page Break Preview" button, resembling a square with two rectangles inside, on the status bar below your worksheet. A solid line marks the page breaks you manually inserted.
Dashed lines represent Excel's automatic page breaks, while solid lines represent your manual page breaks.
To move a page break in Page Break Preview, click on the solid page-break line and drag it to a new area in your worksheet.
To delete a page break in Page Break Preview, select a cell in the column to the right, or the row below, the page break that you wish to remove. Click the "Page Layout" tab, the "Breaks" drop-down command in the Page Setup group and then select "Remove Page Break."
To add a new worksheet to your workbook, click the "New Sheet" button, resembling a plus sign, at the bottom of your worksheet.