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.
You will get a screen like this:
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.
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.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.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.You will get a screen like this:
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.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.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