How to keep printer settings on multiple tabs

[imanitguy]

When printing using multiple tabs (group printing), it only prints the
settings correctly on the first worksheet. Is it possible to do this? I know
I can go into each tab and make the settings, but that's not what we really
want to do.

 

[Frank Kabel]

Hi
select your multiple tabs and go to 'File - Pagesetup' and hit OK. This
should copy the settings from the first worksheet to all other sheets

 

[Gord Dibben]

Some print settings are not available with grouped sheets.

"rows to repeat at top" not available.

"columns to repeat at left" not avilable.

"Print Area" not available.

All else should be available.

Gord Dibben Excel MVP