How to copy print set up to other excel worksheets?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcwhirter - 06 Jul 2006 07:50 GMT

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?

Reply to this Message

Pete_UK - 07 Jul 2006 00:30 GMT

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

> 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?

Reply to this Message