Rasco

Save a workbook with one sheet formatted and page setup as you wish.

FileSave AsFile TypeTemplate(*.xlt)

Save it as SHEET(Excel will add the .xlt)

Store it in your XLSTART folder.

It will be the default InsertWorksheet.

OR if sheets already inserted, follow Frank's advice on grouping.

Gord Dibben Excel MVP

On Tue, 30 Nov 2004 20:49:01 -0800, "Rasc0"
wrote:

I have set up a template in one Excel worksheet and want to be able to paste
it into new worksheets. My problem is that I the have to adjust the page
setup in each new worksheet. Is there a way I can copy the page setup into
the new worksheet?