In Excel 2000 and Excel 2002, you can join non-continuous ranges to form a single contiguous range in order to print them as a single print area.
The Paste All icon is new addition to Excel 2000 and Excel 2002.
Copy two or more separate ranges of cells separately. In Excel 2000 the Paste All icon appears on the Clipboard toolbar. In Excel 2002, press Ctrl+C+C to open the Clipboard pane, or from Edit, select Clipboard.
Select a cell and click the Paste All icon. The ranges that you copied are pasted in order. Now, define these continuous ranges as a single print area and print.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.