Copy Page Setup from Sheet to Sheet?
 

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?

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" wrote in message
...
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?

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?

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" wrote in message
...
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" wrote in message
...
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?