MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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