How to keep printer settings on multiple tabs

I

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.
 
F

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
 
G

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
 
Top