Copy Page Setup from Sheet to Sheet?

  • Thread starter Thread starter blank
  • Start date Start date
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?
 
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
 
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
 
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
 
You must log in or register to reply here.

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

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

Back
Top