I'm trying to print an excel workbook in a particular format. I have several sheets. I would like the information on each sheet to be duplicated directly to the right of the info, on the same printed sheet in Landscape layout. After printing, I need to be able to stack the workbook and cut straight down the middle. This way, I have two identical workbooks with identical margins, perfectly centered.

Is there an easy way to do this without copying and pasting the cell data into the spreadsheet as well?

If there is not, and I must have duplicate tables on the same worksheet, is there an easy way to format the printing so that they print out perfectly aligned?

I've tried to use the ruler function in the print page to stretch, but, it only stretches a particular row/column.

Any help? Thanks.