How to Insert a Page Break in Excel 2013

If you need to print a spreadsheet from Excel 2013, then you are likely familiar with how difficult they can be to format. This becomes more problematic as the spreadsheet gets larger and you need to modify it so that it prints properly. One big issue is that related information can often be split between multiple pages, which can make the printed document difficult to read.

One way to resolve this issue is to manually add page breaks that force certain information to a new page. Using page breaks can be an effective way to customize the way that your spreadsheet prints without dramatically modifying the contents of your spreadsheet.

 

Adding a Page Break in Excel 2013

The steps below will show you how to add a page break to your existing Excel 2013 document. This will force Excel to push cells after the page break to the next printed page. Note that you can remove a page break by clicking on the row under the page break, then selecting the Remove Page Break option from the menu that we will point out below in step 4.

 

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click the row number at the left side of the screen where you want to insert the page break. Note that the page break will be inserted above the row number that you select.

select the row

 

 

Step 3: Click the Page Layout tab at the top of the window.

click the page layout tab

 

 

Step 4: Click the Breaks button in the Page Setup section of the navigational ribbon, then click the Insert Page Break option. Note that the Remove Page Break option is also on this menu.

click breaks, then click insert page break

 

 

You can see a very faint line on the spreadsheet where the page break has been inserted. The page break is identified in the image below. It is very faint, but it is noticeable if you are looking for it.

finding a page break

 

 

There are other ways to modify the way a spreadsheet prints as well. For example, fitting all of your columns on one page can fix a common issue where separate pages are printing with just one or two columns.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.