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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert sheet template loses page setup (2010) 2
Copy formatting (headers, margins, etc) to another sheet? 3
Protect Sheet from Page Setup 3
Page Setup 2
How can I copy page set up options from one sheet to another 1
Copy page layout and margin from sheet to sheet 1
Formatting problem copying sheet 3
Excel Move or Copy Stopped Working? 0

Top