Copy Page Setup from Sheet to Sheet?

[blank]

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?

[N Harkawat]

Right click on any one sheet and then click select all sheets
Now go to page setup
This will change settings on all the pages

"blank" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

[Pank (never old to learn)]

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

[blank]

well well well and to think that for years and years i have not known
you could right click on the sheet tab thanks very very much



"N Harkawat" <[email protected]> wrote in message
news:%[email protected]...
> Right click on any one sheet and then click select all sheets
> Now go to page setup
> This will change settings on all the pages
>
> "blank" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
>
>