Print and page settings of workbook

[David Greenberg]

I am tired of resetting page attributes on similar worksheets within
a workbook. Seems like one should be able to copy print settings
(margins, footers, headings, font, etc. etc.) from one worksheet to
another with one click like the format brush. What am i missing? Must
I write a print macro to do this on each and every multiple set of
worksheets?

 

[JE McGimpsey]

Try selecting the multiple sheets first, then setting the attributes.
Just remember to ungroup them before you make changes that *don't* apply
to all.

 

[David Greenberg]

Thanks!!! don't know why I did not try that before! Saved me mucho
time.

 

[Bob Umlas]

If you've already done one sheet as you like, you can "copy" the page setup
of that sheet to others:
Put the sheets in group mode (ctrl/click or shift/click the sheet tabs),
then activate the sheet which has the page setup settings you want, then do
File/Page Setup and just click OK. All sheets have same page setup now.
Remember to get out of group mode.
(Tips 55 & 56 from my book, "This isn't Excel, it's Magic!")
Bob Umlas

 

[Bruce Sinclair]

If you've already done one sheet as you like, you can "copy" the page setup
of that sheet to others:
Put the sheets in group mode (ctrl/click or shift/click the sheet tabs),
then activate the sheet which has the page setup settings you want, then do
File/Page Setup and just click OK. All sheets have same page setup now.
Remember to get out of group mode.
(Tips 55 & 56 from my book, "This isn't Excel, it's Magic!")
Bob Umlas

I knew the "grouping before" trick ... but your 'copy the settings to other
sheets' trick is magic indeed. Many thanks

 

[Stan Brown]

Wed, 4 Apr 2007 16:52:54 -0400 from Bob Umlas

Put the sheets in group mode (ctrl/click or shift/click the sheet tabs),
then activate the sheet which has the page setup settings you want,

Bob, how do you activate one sheet within group mode? I know about
Ctrl-Click or Shift-Click to select multiple sheets, but as soon as I
click on one sheet the others become deselected.

 

[Dave Peterson]

If I selected all the visible sheets, I can rightclick on any worksheet tab to
activate that sheet--without losing the grouping.

If I selected less than all of the visible sheets, I can just click on one of
the already selected sheets to activate it (without losing the grouping).

(I checked with xl2003.)

 

[Stan Brown]

Sat, 07 Apr 2007 07:52:32 -0500 from Dave Peterson

If I selected all the visible sheets, I can rightclick on any worksheet tab to
activate that sheet--without losing the grouping.

If I selected less than all of the visible sheets, I can just click on one of
the already selected sheets to activate it (without losing the grouping).

Interesting! Visually the other worksheet tabs in the group seem to
go back to unselected, but I tried following your procedure and it
did make the others match the formatting of the selected one. Thanks!

 

[Aviad]

Is there any way to save double side printing settings to all tabs in the worsheet?
The margins and other settings can be copied but the double page printing doesn't
Any idea?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com