How to copy print set up to other excel worksheets?

[Guest]

I want to copy the print set up including page breaks on to multiple
worksheets but when grouped this function is greyed out. Pasting just the
format does not copy the print set ups across to another work sheet. I do
not want this print set up on all my worksheets, just a few.
Anyone know how to copy print set ups to other sheets?

 

[Pete_UK]

How much data have you got in the other sheets? It might be easier just
to copy the main sheet a few times into the workbook using CTRL-drag,
then rename each new sheet and copy/paste data and formulae from the
existing sheets.

Hope this helps.

Pete