View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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