Changing from One Side to Two Sided Printing - HP 2420D

[Bill Allen]

I've got a spreadsheet with multiple tabs.
To change from one sided printing to two sided printing, it seems that I
have to go to each tab, click on page setup, on the page tab select options
and then change from one sided to two sided printing. I can't select all of
the tabs and do this change globally.

Am I doing something wrong?

Is there a better (easier) way to do this?

Thanks,

Bill Allen

 

[Bernard Liengme]

Group the sheet: click on the first tab; hold SHIFT;click on the last tab
Now set the printer option

BTW: You have a WORKBOOK with multiple WORKSHEETS. "tabs" are the do-hickies
(technical term!) that you click to open a worksheet. Knowing the right
terms make it easier to communicate and to get better results from Help

best wishes

 

[Bill Allen]

Thanks for the coorections.

I've tried grouping the tabs, but this only changes the first tab.

Bill

 

[Gord Dibben]

There are some print features that cannot be done to grouped sheets.

i.e. print range and rows to repeat at top

I don't have a duplex printer to test but this feature may be one of those not
available.

You can do each individually or go the macro route to print all odd pages then
flop paper over and print all evens.

See Ron de Bruin's site.

http://www.rondebruin.nl/print.htm#odd


Gord Dibben MS Excel MVP