printing
Does anyone know how to print multiple excel pages on one sheet of paper?
-- rp |
printing
I don't know a straightforward way but her goes:-
Assume you have data ranges on Sheet 1 and sheet 2 you want to print together and a blank sheet, Sheet 3. name both your data ranges on sheets 1 & 2 by selecting them and insert|name|define. Highlight range 1 again and press ALT+Shift and tap E then tap C A window appears, accept the default as shown on screen on press OK Navigate to the sheet where it will print and paste it in with CTRL+V Drag and size it to put it precisely where you want Repeat this for the second data range Now you mist link each object to the original data so it will change when updated so select the object and type = and then enter the name you defined for it in the formula bar and press the tick. Do this for all objects and your done. When you want to print then print sheet 3. Mike "Rosa" wrote: Does anyone know how to print multiple excel pages on one sheet of paper? -- rp |
printing
Thank you Mike, this sounds like a solution for me. rp
-- rp "Mike H" wrote: I don't know a straightforward way but her goes:- Assume you have data ranges on Sheet 1 and sheet 2 you want to print together and a blank sheet, Sheet 3. name both your data ranges on sheets 1 & 2 by selecting them and insert|name|define. Highlight range 1 again and press ALT+Shift and tap E then tap C A window appears, accept the default as shown on screen on press OK Navigate to the sheet where it will print and paste it in with CTRL+V Drag and size it to put it precisely where you want Repeat this for the second data range Now you mist link each object to the original data so it will change when updated so select the object and type = and then enter the name you defined for it in the formula bar and press the tick. Do this for all objects and your done. When you want to print then print sheet 3. Mike "Rosa" wrote: Does anyone know how to print multiple excel pages on one sheet of paper? -- rp |
printing
If you use the camera tool to take a picture of the ranges and paste the
pictures on a new sheet you will find that the ranges will update as the original is changed. No need for the linking formulas. Gord Dibben MS Excel MVP On Fri, 6 Jul 2007 12:46:00 -0700, Rosa wrote: Thank you Mike, this sounds like a solution for me. rp |
All times are GMT +1. The time now is 07:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com