| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting print preferences on multiple tabs
I have a client who only accepts single sided prints. When i have a workbook
with multiple tabs how do I change the print preferences for the entire workbook. At the moment I have to go to each tab and change the print preferences individually which is taking ages! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting print preferences on multiple tabs
Have you tried grouping all the tabs together, then setting your preferences?
click on the 1st tab, scroll to the last tab, holding down the sift key, click the last tab "jools" wrote: I have a client who only accepts single sided prints. When i have a workbook with multiple tabs how do I change the print preferences for the entire workbook. At the moment I have to go to each tab and change the print preferences individually which is taking ages! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting print preferences on multiple tabs
Yes
tried this and it doesn't work unfortunately I am sure there must be a way of doing it though "Stout" wrote: Have you tried grouping all the tabs together, then setting your preferences? click on the 1st tab, scroll to the last tab, holding down the sift key, click the last tab "jools" wrote: I have a client who only accepts single sided prints. When i have a workbook with multiple tabs how do I change the print preferences for the entire workbook. At the moment I have to go to each tab and change the print preferences individually which is taking ages! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting print preferences on multiple tabs
Anyone?
"jools" wrote: Yes tried this and it doesn't work unfortunately I am sure there must be a way of doing it though "Stout" wrote: Have you tried grouping all the tabs together, then setting your preferences? click on the 1st tab, scroll to the last tab, holding down the sift key, click the last tab "jools" wrote: I have a client who only accepts single sided prints. When i have a workbook with multiple tabs how do I change the print preferences for the entire workbook. At the moment I have to go to each tab and change the print preferences individually which is taking ages! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting print preferences on multiple tabs
What property didn't work?
Lots of them do get changed if you group the sheets first. Some can't be. The only alternatives are to do it one-by-one or to create a macro that does what you want to each sheet. Recording a macro when you do it once could be useful. Eliminate the things you don't want to change. And tweak the macro to cycle through all(?) the worksheets in the workbook. (or run that same macro against each worksheet via tools|macro|macros) jools wrote: Anyone? "jools" wrote: Yes tried this and it doesn't work unfortunately I am sure there must be a way of doing it though "Stout" wrote: Have you tried grouping all the tabs together, then setting your preferences? click on the 1st tab, scroll to the last tab, holding down the sift key, click the last tab "jools" wrote: I have a client who only accepts single sided prints. When i have a workbook with multiple tabs how do I change the print preferences for the entire workbook. At the moment I have to go to each tab and change the print preferences individually which is taking ages! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I print multiple tabs on one page? | Excel Discussion (Misc queries) | |||
| format rows to print at top for multiple tabs | Setting up and Configuration of Excel | |||
| how to print a complete workbook with multiple tabs on both sides | Excel Worksheet Functions | |||
| Print multiple tabs on one page | Excel Discussion (Misc queries) | |||
| set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Linear Mode
