Copying Print Options
Is there a way to copy print options from one worksheet tab to another?
|
Copying Print Options
Some of them...
Group your worksheets. Select the "sending" worksheet tab first. Then ctrl-click on the "receiving" tabs. Then do the File|page setup stuff Lots (not all) of those settings will be applied to all the sheets that are grouped together. Then make sure you ungroup your worksheets. IlliniEric wrote: Is there a way to copy print options from one worksheet tab to another? -- Dave Peterson |
Copying Print Options
Choose FilePage Setup and click OK on the worksheet you want to copy the
settings from then select another sheet and choose EditRepeatPage setup [or Press the F4 key]. (The worksheets do not need to be in the same workbook) If you want to copy print settings across multiple sheets in a workbook, click on the tabs while holding down Ctrl (or Shift), then click the tab to copy setups from, so it is active, and select File Page Setup OK. "IlliniEric" wrote: Is there a way to copy print options from one worksheet tab to another? |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com