I just tried that and I got the first 12 of 31 changed to the new settings.
From worksheet 13-31 the old settings still appear.

"dominicb" wrote:


Good morning tccc1219

Try this trick.

Select the sheet you want to use as the source. Then, with ctrl held
down, select all the sheets you want to copy the settings to. Then
goto File Page Setup and when the dialog box appears clickOK. All
the print settings will then be copied across.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=384437