copy page settings to multiple worksheets in excel?
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? |
copy page settings to multiple worksheets in excel?
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. mcwhirter wrote: 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? -- Dave Peterson |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com