Printing Multiple Selections

You may have a need at times to print out a group of selections from different worksheets and have them appear on a single sheet of paper. Perhaps the easiest way to do this is to simply set up a "consolidation" worksheet that you would actually use for your printing. Follow these general directions:

1. Create a new worksheet to be used for consolidation/printing.
2. Select the range on the worksheet that you wish to print.
3. Press Ctrl+C to copy the selection.
4. Go to the new sheet and select the cell where you want the information to appear.
5. Choose Paste Special form the Edit menu. (In Excel 2007, display the Home tab of the ribbon and click the down-arrow under the Paste tool at the left side of the ribbon. Select Paste Special from the resulting menu.) Excel displays the Paste Special dialog box. (See Figure 1.)



Figure 1. The Paste Special dialog box.

6. Click on Paste Link. The dialog box disappears and the linked information appears in the worksheet.
7. Repeat steps 2 through 6 for any other ranges you want included on the printout.
8. Print the worksheet with the consolidated information.

The one big drawback to this approach is that if the worksheets from which you are copying have radically different formatting, you may not be able to merge them into a consolidated worksheet satisfactorily. (You will need to adjust the formatting in the consolidation sheet after pasting the different ranges.) In this case you may need to adjust formatting to get exactly the effect you desire.