Print Areas from Several Excel 2000 Worksheets on the Same Page 

Do you have data on two or more Microsoft Excel 2000 worksheets that you'd like to print out on a single page? There's an easy way to get the combined printout, even if the worksheets are in different workbooks. On a new worksheet, create links to the data that you want to print together, and then print the new worksheet.

For example, you have a PivotTable® report that summarizes recent sales on one worksheet, Summary:

On another worksheet, Details, you have some specifics of the sales data:

You plan to continue keeping the report and the details on separate worksheets, perhaps in separate workbooks, but you want to print them on the same page. Here's how:

1. Open or create a new, blank worksheet. For example, you could add a sheet to the workbook and name it Combined.
2. Select the range of data that you want appear first on the page. For example, you could select the PivotTable report on the Summary worksheet by clicking a cell in the report, pointing to Select on the PivotTable menu on the PivotTable toolbar, and then clicking Entire Table.
3. On the Edit menu, click Copy.
4. On the new Combined worksheet, click the upper-left cell of the area where you want the data to appear. For example, to place the PivotTable report at the top of the page you could click cell A1.
5. On the Edit menu, click Paste special, and then click Paste Link. The data from the PivotTable report appears.
6. Format the cells containing the linked data as needed. For example, to format the cells on the Combined worksheet to match the original range of data, click Paste special again, and then click Formats.
7. Now go to the worksheet containing the next range of data that you want to print on the page, and select the next range of data. For example, you could click the Details tab and then select A1:C8.
8. On the Edit menu, click Copy.
9. On the Combined sheet, click where you want the second range of data to appear. For example, you could click cell A7 to put the detail data under the report.
10. On the Edit menu, click Paste special, and then click Paste Link. To copy the formatting too, click Paste special again, and then click Formats.
    Here's what the combined worksheet looks like:

    

    Depending on where you paste the second range of data, you may also want to adjust column widths or row heights. Formatting and adjustments affect only the combined worksheet, not the original worksheets that you're linking to.

11. Continue these steps to copy and paste links to all of the data that you want to print together on the page.
12. When you've created all the links, set any print options you want, and then print the worksheet. For more information about setting print options, type print settings in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

Use the combined worksheet for printing purposes, and continue to maintain your data on the original worksheets. When you open the workbook containing the combined worksheet, make sure you update links, and the combined worksheet will always reflect the latest changes to the original data.