Show All

Hide All

Do you have data on two or more Excel worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) that you'd like to print out together? There's an easy way to create a combined printout, even if the worksheets are in different workbooks. Simply create links to the data you want to print together on a new worksheet, and then print that worksheet.

For example, say you have a PivotTable® report that summarizes recent sales on a worksheet called Summary.

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

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

1. Click the worksheet tab of a blank worksheet or add a new worksheet.

   For example, you could add a worksheet to the current workbook and name it Combined (as shown in the previous picture).

   How?

   1. On the Insert menu, click Worksheet.
   2. Right-click the worksheet tab, and then type the name you want to use.

2. Select the range of data that you want to appear first on the page.

   For example, you could select an entire PivotTable (as shown on the Summary tab in the picture above).

   How?

   1. Click any cell in the PivotTable report.
   2. On the PivotTable toolbar, point to Select on the PivotTable menu, and then click Entire Table.

3. On the Edit menu, click Copy.
4. On the new worksheet, click the upper-left cell of the area where you want the data to appear.

   For example, cell A1 (as shown in the picture above).

5. On the Edit menu, click Paste special, and then click Paste Link.

   The PivotTable report appears in the new worksheet and is linked to the original data.

6. To copy the formatting too, click Paste special on the Edit menu again, and then click Formats.
7. Activate the worksheet containing the next range of data that you want to include in your printout, and select that range of data.

   For example, A1:C8 could be selected in the Details worksheet (as shown in the picture above).

8. On the Edit menu, click Copy.
9. On the new worksheet, click where you want the second range of data to appear.

   For example, cell A7 (as shown in the following picture).

10. On the Edit menu, click Paste special, and then click Paste Link.
11. To copy the formatting too, click Paste special on the Edit menu again, and then click Formats.

    The combined worksheet will look like this:

    

    Tip  Depending on where you paste the second range of data, you may also want to adjust column widths or row heights. Additional formatting and adjustments affect only the combined worksheet, not the original worksheets that the data is linked to.

12. Continue these steps to copy and paste links to all of the data you want to combine in one worksheet.
13. 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.

Tip  As you use the combined worksheet for printing purposes, you can maintain the data on the original worksheets. To print the most current data, you need to make sure that the linked data is updated when you open the workbook that contains the combined worksheet. That way, the combined worksheet will always reflect the latest changes to the original data.