Why Isn’t My Entire Spreadsheet Printing in Excel 2010?

You can apply a lot of different formatting to a document in Microsoft Excel 2010. This formatting can affect the data contained within your cells, the way that the data looks in those cells, or even the way that a spreadsheet prints out on paper.

Many of these formatting choices are invisible, and it can be difficult to undo a setting when you are working on a file that was edited or created by someone else. One common issue that can arise is when you are trying to print your spreadsheet, but only part of the sheet is printing. This occurs because the last editor set a print area, which changes the data that Excel thinks you want to print. Fortunately you can undo a print area that has been set by following our simple tutorial below.


How to Clear the Print Area in Excel 2010

The steps in this article will assume that you are currently attempting to print a spreadsheet, but that only a subset of the cells in that spreadsheet are being printed. Once you have completed these steps, your entire spreadsheet will be printable.


Step 1: Open the spreadsheet in Excel 2010.


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

click the page layout tab



Step 3: Click the Print Area button in the Page Setup section of the navigational ribbon, then click the Clear Print Area button.

choose to clear the print area



You should now be able to navigate to the Print menu and print the entire spreadsheet.


Are there one or two extra columns that are printing on additional pages, causing you to waste paper? Learn how to change the print layout of your Excel spreadsheet so that all of the columns print on one page.

solveyourtech.com newsletter

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