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
mcwhirter wrote:
[Quoted Text] > 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?
|