copy page settings to multiple worksheets in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have excel 2002. I have multiple worksheets in a workbook. I changed and
reset the page setup in one sheet to have a certain size (57%), margins and
page breaks so it would print OK. I wanted to group the sheets and do this to
all worksheets but the page settings are not saved on the other sheets. How
can I copy this format to multiple sheets and also copy this format to other
workbooks?
 
I just tried grouping sheets in xl2003 and the "adjust to" percentage changed
for each worksheet in the grouped worksheets.

And if I grouped sheets and then did Insert|page break, they went through to all
of the grouped sheets, too.

I'd try once more if I were you.
 

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

Excel - Problem w/ printing more than one worksheet with same sett 0
How to copy print set up to other excel worksheets? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy of Print Setup 2
Update multiple spreadsheets in multiple workbooks 0
Gridlines do not print, it is selected in sheet setup 3
Using VBA to copy data into another worksheet ??? 2

Back
Top