Change Print Quality for entire workbook
Is there a way to change the Print Quality for all tabs in a workbook without
going to each individual tab and changing the setting there? I have a 70 tab workbook where chaning the print setup individuality would be time prohibitive. |
Change Print Quality for entire workbook
dnguyen411, give this a try,
With the sheet that has the correct settings active, right-click on the sheet tab and select "Select All Sheets", then use File/Page Setup and immediately click OK (don't change anything). Click on some other worksheet to get you out of "Group" mode now all sheets should have the same page settings! -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "dnguyen411" wrote in message ... Is there a way to change the Print Quality for all tabs in a workbook without going to each individual tab and changing the setting there? I have a 70 tab workbook where chaning the print setup individuality would be time prohibitive. |
All times are GMT +1. The time now is 05:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com