Depress the right mouse button on a tab sheet and select all sheets.

Select Page setup and do what you have to.

Depress the right mouse button on a tab shhet and select ungroup, failure
will result in things you do to one sheet being replicated in all the sheets
(including deleting cells).

HTH - Pank

"blank" wrote:

Is there a simple way to copy the page setup (eg margins, page orientation)
or must I continue to go through the whole process for each sheet?