Copy Page Setup from Sheet to Sheet?

B

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

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
 
P

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
 
B

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
 
Top