If you click on the Select All area (the little grey square to the
left of ColA and above Row1), then the whole sheet will be selected.
If you copy and then go to your other sheet, select A1 and Paste
Special Formats, then it's done.
Rgds,
ScottO

"Pete" wrote in message
oups.com...
| If you copy the sheet into the same workbook then all formats will
be
| preserved - the easiest way I find is to select the worksheet you
want
| to copy, then hold the CTRL key down while you drag the worksheet
tab -
| a small black arrow will indicate where the new sheet will be
copied
| to, and release CTRL when you have it positioned correctly. A "
(2)"
| will be added to the original worksheet's name (or " (3)", or "
(4)"
| etc depending how many copies you make).
|
| Of course, you may need to remove data and formulae from the copied
| sheet.
|
| Hope this helps.
|
| Pete
|