Sometimes there is a need to print out a medley of selections from different worksheets and have them all on one sheet of stationery.
You can do this by setting up a “Print” worksheet that you use for printing.
Follow the steps below to learn how:
- Create a new worksheet to be used for printing purposes.
- Select the range on the worksheet that you would like to print.
- Click the shortcut key combination Ctrl + C to copy your selection.
- Move to your new Print sheet and select the cell where you would like your copied data to appear.
- Click on Edit | Paste Special in version 2003 and in versions 2007 – 2010, click on the Home tab of your Ribbon and click the down-arrow under the Paste tool at the left side of your Ribbon and select Paste Special from the menu displayed.
- The Paste Special dialog box will open.
- Click on Paste Link. The dialog box will disappear and the linked information will appear in your worksheet.
- Repeat the steps above for any other ranges you would like included on your printout.
Then print your worksheet with the information.
The only problem you may encounter using this method is that if the worksheets from which you are copying have different formatting, you may not be able to merge them into a consolidated worksheet to your satisfaction. In that instance, you will need to adjust the formatting in your consolidation worksheet after you paste the different ranges.