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.
Step 3: Click the Page Layout tab at the top of the window.
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.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.