![]() |
|
|
Text Version
Beauty & Self Books & Music Career Computers Education Family Food & Wine Health & Fitness Hobbies & Crafts Home & Garden Money News & Politics Relationships Religion & Spirituality Society & Culture Sports Travel & Leisure TV & Movies
|
Print Area – Excel By default, Excel will select a print area that will incorporate the entire area of the worksheet that contains data. You may want to segment different areas for printing. There are two methods for setting the print area: • Using the Sheet Options tab of the Page SetUp dialog box • Using File | Set Print Area Both methods will be described here. Sheet Options Tab To activate: • File | Page SetUp • Select the Sheet Options Tab At the top of the Sheet Options Tab you will see the Print Area field. Using this option you can establish a specific print area. To define a print area, click inside the print area field and type the print range desired or use the collapse button found to the right of the print area field to collapse the dialog box, then select the range directly in your worksheet. Once the range has been selected, click on the collapse button again to restore the dialog box. Click on OK when finished. File | Set Print Area To use this option, you must first pre-select the range you want to include in your print area. • Pre-select desired print range • Click on File | Set Print Area Clearing the Print Area • Click on File | Clear Print Area TIP When you have multiple ranges that you need to print on a regular basis, use the named range feature to predefine each of the print areas: i.e., PrintRange1, PrintRange2 etc. Then you can use the Name Box to select the needed print area then use the Set Print Area command to set your print range. Using named ranges can speed up your process.
Content copyright © 2008 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Chris Curtis for details.
|
![]()
|
| About BellaOnline | Privacy Policy | Advertising | Become an Editor | Website copyright © 2008
Minerva WebWorks LLC. All rights reserved.
|