Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
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.
Re: Print Multiple ranges in one sheet of paper
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.