how do I copy a page setup fron one workbook to another

C

claude jerry

I did not understand what you mean by set up. . I asume you mean it to be
format
try this

1. go to your original file press ctr+A (Select all)
2. press ctr+c (copy)
3. go to the new file
4. press ctr+v (paste)
5. press del key ( it will delete all data)

what you get is the format of the original file without any data in it !
 
G

Gord Dibben

Your subject line says "workbook" but your body text says "sheet".

To copy page setup from one sheet to all sheets within a workbook, just select
all sheets by right-click on a sheet tab then do your page setup on the active
sheet.

Will be done to all.

Note: exceptions..........print range cannot be set, rows to repeat at top
cannot be set.

For workbooks, there is no way except to create a template with your settings
then use that template as the basis for all new workbooks.


Gord Dibben MS Excel MVP
 
Top