Printing 2 sided from different worksheets
group the sheets before you print them. Click on the first worksheet tab,
then hold down the shift key and click on the last worksheet tab.
To ungroup, right click on one of the tabs and select ungroup.
Be cautious - when grouped, if you make a change on one sheet, it is made on
all sheets in the group.
--
Regards,
Tom Ogilvy
"Liam B" wrote in message
...
Hi Everyone,
I have 8 excel sheets with one printable page on each sheet in an excel
workbook. I want to be able to print two sided so that I end up with 4 (2
sided) printed sheets. I know how to print two sided when different pages
are on a single excel worksheet but I don't know how to do it when they are
on different excel worksheets but in the same excel workbook. I would be
very grateful if someone could help me on this.
Regards,
Liam.
|