Copying Print Options

D

Dave Peterson

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.
 
L

Lori

Choose File>Page Setup and click OK on the worksheet you want to copy the
settings from then select another sheet and choose Edit>Repeat>Page 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.
 
Top