Multiple print ranges
Posted by John on October 31, 2000 2:00 PM
Is it possible to have multiple print ranges set in one document? I have one huge spreadsheet, however I have to print different information from this report to different people. Currently I have to go to each portion and reset the print range. Any help would be appreciated!
Posted by Ivan Moala on November 01, 2000 12:04 AM
As a quick work around you could define your print
ranges eg. Select the areas to print by highlighting
Then in the names Box avail. in the Formula bar
type in the name, repeat until you have the names
and the reference ranges.
Eg you may have Peter_Rpt,Mine,Msoft etc.
When you want to print them just click in the drop
down name box and select the name. This will highlight
the area. Now select File / Print in the dialog
box [Print what] select SELECTION.
Note: don't use the print icon to do this.
HTH
Ivan
Posted by John Bingham on November 02, 2000 12:31 PM
There is a free report manager add-in for this. enter "report manager" in your help search.
