blaz,
Another option is to use Excel's "Camera" to take a "picture" of each range, and place each picture on a it's own separate sheet - where you can set the page-setup settings uniquely for each report - including separate headings if you prefer. Then, all you'll need to do is click on whichever sheet-tab you want to print, and then print as you normally would - i.e. <Control> P <Enter>, or use the Print icon.
An important point about these "pictures", is that they are "linked" to your original data. Therefore, any changes you make to your original data, including inserting/deleting rows/columns, will automatically be reflected in the pictures.
There is a "Camera" icon that you can place on one of your existing toolbars. These are the steps involved.
1) From the menu, choose: Tools - Customize
2) Click the "Commands" tab.
3) Under "Categories" (left side), click on "Tools".
4) Under "Commands (right side), scroll down until you find the "Camera" icon - it's near the bottom.
5) Click-and-drag the icon to one of your existing toolbars.
In using the Camera...
a) Highlight a range (one range at a time),
b) Click the "Camera" icon. This will cause the mouse-pointer to change to a plus character... +
c) Click on a separate sheet (create a new sheet ahead of time if required).
d) Left-click to drop the picture. Once you've dropped it, you can easily move it around.
And a "bonus"... If desired, you can easily "enlarge" the picture - by clicking-and-dragging a "corner" handle. And you can "stretch" the picture - by clicking-and-dragging one of the "middle" handles.
Note... If you have assignd range names to the individual ranges, you can use these range names with your pictures. While clicked on the picture, simply type: =xxx ...where you replace "xxx" with your range name, and <Enter>.
A final note: In this particular case, it's a matter of wanting to print separate ranges on SEPARATE pages. There can be other situations where this Camera option is very useful in being able to place disjointed ranges together on ONE sheet. For example, different data that needs to be in separate areas because of requiring different column widths or some other reason, but then needs to be printed on ONE sheet - perhaps as part of a special form that shows this "collection" of data (pictures).
I hope this helps.
Please advise as to how useful you find this option. I'm confident that once you start using this "Camera" (picture) option, you'll discover other areas where you can take advantage of your new-found "photography skills".
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
