Since there is no data yet, can't you just make a copy of the entire sheet.
Under the Edit menu, Move or Copy Sheet, check Create a Copy.
If I'm missing something as to why you can't do that, you could select the entire sheet and copy. Then, paste special the formats to the new sheet. This would get everything except the headers.
>I setup the formatting on sheet1 (no data yet, just headers and formats like font borders etc.)
>Now I would like to create a sheet2 whith the same formatting?
>
>How can I do that??
>
>
>Peter
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23