Print Multiple ranges in one sheet of paper
Posted by John on December 27, 2001 8:06 PM
Is it possible to print multiple ranges in one sheet of paper? I have labels in column G1:G3, A6:A8, A10:A20, my data start on column C10:AB20, G1:G3, A6:A8, and A10:A20 must repeat on every page, plus the new data. Right now I set it as seperate page for each time that I print, Please help.
Posted by Jacob on December 27, 2001 8:15 PM
Hi
There is a feature in Excel that can do this. Go to tools|customize then Commands|Tools then find the camera icon. Put the icon on one of your toolbars. No highlight the area you want to print and click the camera. It will take a snapshot that will continually update. Take as menu pictures as you want and arrange then how you want and they will print together.
Hope this helps
Jacob
Tool
