software

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 quot;adjust toquot; 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.

mcwhirter wrote:
gt;
gt; I have excel 2002. I have multiple worksheets in a workbook. I changed and
gt; reset the page setup in one sheet to have a certain size (57%), margins and
gt; page breaks so it would print OK. I wanted to group the sheets and do this to
gt; all worksheets but the page settings are not saved on the other sheets. How
gt; can I copy this format to multiple sheets and also copy this format to other
gt; workbooks?

--

Dave Peterson