How to View the Print Area in Excel 2010

Excel spreadsheets that were created by or edited by other people can often have formatting that is not immediately visible when you first view the document.

Many of these formatting choices are related to printing, and you might not notice them until after you have tried to print the spreadsheet.

One such option is the print area, which is something that can be defined within Excel, and essentially tells Excel that you only want to print a certain part of the spreadsheet.

But rather than printing the spreadsheet and wasting paper to view the print area, there is another method that you can use to view your print area in Excel 2010.

Our short guide below will list the steps necessary to easily tell which part of your spreadsheet will print, as defined by the print area settings.

Show the Print Area in Excel 2010

The steps in this article will show you how to view the portion of your spreadsheet that has been designated in the print area.

If you do not want to have a print area for your spreadsheet, and would instead prefer to print the entire document, then you can read this article to learn how to clear the print area.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Click the View tab at the top of the window.

click the view tab

Step 3: Click the Page Break View button in the Workbook Views section of the navigational ribbon.

click the page break view button

The print area is the part of the spreadsheet in this view that is white, with a page number watermark behind it. The grayed-out part of the spreadsheet is the rest of your worksheet that is not included in the print area.

locate the print area

Now that you know how to view the print area in Excel 2010, you can have a better idea of the content in your spreadsheet that will be included in the printed version.

Are there one or two columns of your spreadsheet that are printing on their own piece of paper? Read here to learn how to force them to print with the rest of the columns in your spreadsheet.

Join Our Free Newsletter

Featured guides and deals

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