Is there any one know how to apply below set up for the 'whole workbook'?
1) the margining of all the worksheets
2) print all the worksheets contents in landscape
Thank you for your help

Anna, give this a try.

Group the worksheets you want to change

Click on the first tab and ctrl-click on the other tabs, if you want all the
sheets right click on one and choose select all sheets.

Then do the page setup, most settings will be copied

If you already have one sheet set up like you want then 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 now all sheets should have the same page
settings!

There are two EXCEPTIONS that I can think of
Print Range
Rows to repeat at top
Cannot be copied this way


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

"Anna" wrote in message
...
Is there any one know how to apply below set up for the 'whole workbook'?
1) the margining of all the worksheets
2) print all the worksheets contents in landscape
Thank you for your help