Is it possible to copy a header/footer from one worksheet to anoth

D

DLC

Would appreciate if anyone can tell me if it is possible to copy a
header/footer from one sheet to another or do you have to select the multiple
tabs when creating? Also when copying formats can you copy the page setup
settings?
 
D

Dave Peterson

If the worksheets are in the same workbook, select the "parent" sheet first,
then ctrl-click on the "child" worksheet tab.

Then do file|page setup.

Then remember to ungroup the sheets and check to see if it worked.

If the worksheets are in different workbooks, copy the parent to the other
workbook, do the stuff and delete it when you're done.
 
Top