Google search

Custom Search

Wednesday, July 7, 2010

How to Print Selected Areas of a Spreadsheet in Excel 2010

The Excel spreadsheet often has many cells, but sometimes you only need to print special areas of the spreadsheet. Here is the way to print out only specific areas of the document that you need.

Step 1. Highlight the area of the document in Excel 2010

You need to open the Spreadsheet you need and hold down the Ctrl key while highlighting the area of the document you want to print out.

How to Print Selected Areas of a Spreadsheet in Excel 2010-area

Step 2. Go to Set Print Area in Excel 2010

In this step you need to click on the Page Layout on the Ribbon, and then hit on the Print Area button, next to the Set Print Area.

How to Print Selected Areas of a Spreadsheet in Excel 2010-set  print area

Step 3. Page Setup in Excel 2010

The Page Setup window appears. Just select the Sheet tab. Now you need to type in the Columns and Rows that you want to repeat. And then click on Print Preview. Doing this and you can include any headers or labels associated with the data.

How to Print Selected Areas of a Spreadsheet in Excel 2010-page  setup

You will get a screen like this:

How to Print Selected Areas of a Spreadsheet in Excel 2010-preview

Step 4.  Select multiple areas of the spreadsheet

Sometimes you have to select multiple areas of the spreadsheet. Now that you have select one you just need to select another area and then click on Print Area and Add to Print Area.
 
How to Print Selected Areas of a Spreadsheet in Excel 2010-multiple areas
 

Step 5. Preview and set the printing options in Excel 2010

Once you click on Print Preview, Backstage View opens and you can make your own printing options from there.

How to Print Selected Areas of a Spreadsheet in Excel 2010-printing options

This is really a good method of saving ink and paper if you only need to print out specific areas of a spreadsheet in Excel 2010.

No comments:

Post a Comment