Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy formats from sheet 1 to sheet 2
Message
 
À
07/01/2005 12:13:50
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
00975163
Message ID:
00975464
Vues:
15
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform