Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set default to print out the entire workbook | Setting up and Configuration of Excel | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
changing print area in an entire workbook | Excel Worksheet Functions | |||
How do I change the print quality? | Excel Discussion (Misc queries) | |||
Why can't I change the print quality in Excel? | Excel Discussion (Misc queries) |