Demonet, here is one way,
With the sheet that has the correct settings active, right-click on the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode and you'll also notice that all sheets have
the same page settings!


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"DEMONET48" wrote in message
...

THANK YOU VERY VERY MUCH, HAVE PLAYED WITH IT SEVERAL DIFFERENT WAYS AND
SEEMS TO BE WORKING GREAT.

"Paul B" wrote:

Demonet, here is one way,
With the sheet that has the correct settings active, right-click on the
sheet tab and select "Select All Sheets", then use File/Page Setup and
immediately click OK (don't change anything). Click on some other worksheet
to get you out of "Group" mode and you'll also notice that all sheets have
the same page settings!


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"DEMONET48" wrote in message
...