Print data from two sheets on one page
Print data from two sheets on one page
|
Tip I received a message from a reader who switched from 1-2-3 to Excel and was wondering how to print data from two different sheets in a file onto one page of a report. Hang on a sec -- I'll tell you how. Suppose you have an Excel workbook where Sheet1 looks like the figure below.  Sheet2 looks identical, except the data is for Group B. You want to print the Group B stuff just beneath Group A, on a single sheet. Go to Sheet2. Select View--Toolbars and click Customize. In the Categories list, click Utility. Drag the camera tool from the Buttons section of the Customize dialogue box on to the worksheet, then close the dialogue box. On Sheet2, select A1:D6 and click the camera tool. Return to Sheet1 and click cell A7. You'll get an image of the Group B data just below Group A. Press and hold down <Alt> as you drag the picture into position. (The <Alt> key causes objects to snap to the worksheet grid.) If there's a border around the image, select it and choose Format--Object. Click the Patterns tab, and in the Border area select None and click OK. The figure below shows the result.  In 1-2-3, just select File--Print, click All worksheets, and then click OK. To print only from selected sheets, choose Selected Range in the Print dialogue box and enter a print range that looks like A:A1..A:D6, B:A1..B:D6. In Quattro Pro, select File-- Print and choose Notebook or specify multiple blocks under Block Selection. - Richard Scoville | Category: Spreadsheet Issue: Jul 1997 Pages: 176-177 |
These Web pages are produced by Australian PC World © 1997 IDG Communications