How do I copy page setup from one worksheet & paste into new shee.
 

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?

Hi
if this sheet is the first in your workbook try:
- select this sheet and the other sheet(s). Hold down the CTRL key to
group the sheets
- goto the page setup dialog and simply hit OK

--
Regards
Frank Kabel
Frankfurt, Germany

"Rasc0" schrieb im Newsbeitrag
...
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?

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?