![]() |
How to make all worksheets pull from the same tray
How can I make all worksheets pull from the same trays without opening going
to each individual worksheet --File -- Page Setup -- click on "Options" button? Then on the printer select the Paper Source which we want Tray 2. The only way I have found to change the paper tray setting for each worksheet is have do the steps about to each worksheet. Other wise only the worksheet that I have specified to print Tray 2 will print to Tray the others will default to Auto (which is LCT). I have tried right clicking on the worksheet that has the settings I want then choosing "Select All" then apply these settings to the rest of the worksheets but that does not work. I even tried making acros but that did not work either. Any help you can give would be much appreciated. |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com