 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Changing from One Side to Two Sided Printing - HP 2420D
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 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  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > I've got a spreadsheet with multiple tabs. > To change from one sided printing to two sided printing, it seems that I [quoted text clipped - 9 lines] > > Bill Allen Thanks for the coorections. I've tried grouping the tabs, but this only changes the first tab. Bill > Group the sheet: click on the first tab; hold SHIFT;click on the last tab > Now set the printer option [quoted text clipped - 18 lines] >> >> Bill Allen 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 >Thanks for the coorections. > [quoted text clipped - 24 lines] >>> >>> Bill Allen
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.