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

If you have finished creating or editing a spreadsheet in Microsoft Excel and then gone to print it out, you might find that it hasn’t printed all of the rows.

Excel is notoriously difficult to print from, but often those issues are related to the spreadsheet not fitting properly on the page, or not including gridlines to separate all of the cells.

If the problem you are encountering involves Excel not printing all rows, then it’s typically related to something called a print area.

Our guide below will show you how to clear the print area from your spreadsheet so that you can print all of your data.

How to Fix Excel Not Printing All Rows

  1. Open your spreadsheet.
  2. Choose the Page Layout tab.
  3. Click the Print Area button and select Clear Print Area.

Our guide continues below with additional information on Excel not printing all rows, including pictures of these steps.

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 (Guide with Pictures)

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.

Now that you know how to fix the problem of Excel not printing all rows you will be able to start using the print area to your advantage if you only need to print part of a spreadsheet in the future, or if you need to print a blank 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.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy