Format multiple tabs for printing

[Sigh]

I have a file containing 22 tabs, I would like to print them all one-sided, is there a way to format without going into each tab separately?

 

[Mister H]

Hi Sigh:

I think you should be able to just right click on a Tab and select Select All Sheets then go ahead and do your File/Page Setup

When your Formatting is complete MAKE SURE YOU RIGHT click on the Tabs again and select Ungroup Sheets. If not anything you type on one sheet will be typed on ALL sheets.

Hope this helps,
Mark

 

[Sigh]

Hi Mark, thanks for your reply. I tried exactly that first of all, the first tab printed one-sided but all the others printed two-sided as that is the default setting. I'm really stuck!

 

[Mister H]

So if you select all Sheets and do the following:

File/Page Set Up.../ and then Click the Options buttion

What appears on the Finishing tab under Document Options? Is there a checkmark in Print On Both Sides? If not then I too am confused

Let me know.
Mark

 

[Sigh]

The checkmark is on 'print one-sided' but it only appears to work on the first tab! If I deselect all tabs and go into the first one it is still one-sided but all the others are 'print two-sided'. Looks like my only option is to go into every tab and format them separately, something I was obviously hoping to avoid, it all seems very odd.

 

[Mister H]

Not really sure why it doesn't work. You may have to go in as you said and do it one at a time. Weird that it works at my end but it is just a blank file I tried it with. Did you try making the change on something other then the first Tab. Just curious as Excel seems to act weird sometimes and you can sometimes get around it behavior by playing around. I would try selecting all Tabs and then click on a Tab that has the double sided set up and remove it. Barring that you could also try setting them to 2 sided and then select the Tabs again and change it to 1 sided. Just a thought... If it still doesn't work then you might have to go one sheet at a time unless someone else can give you a macro.

SORRY I could not be of assistance.

Take Care,
Mark

 

[Sigh]

Yes, it is weird. I went into each tab separately in the end, I'm thinking it might be a change our IT people have made, but thanks again for your suggestions.