Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Print Options
Is there a way to copy print options from one worksheet tab to another?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print area options | New Users to Excel | |||
How to set DEFAULT print options in Excel to print gridlines? | Excel Discussion (Misc queries) | |||
print options | Excel Discussion (Misc queries) | |||
Any way toturn off the "Auto Fill Options" pop-up after copying ce | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel |