Copy worksheet and keep all formating
 

Hi
How do I copy a worksheet and keep the header/footer etc?
Martin
©¿©¬

Copy worksheet and keep all formating
 

You can do a CTRL-drag of the worksheet tab, either into the same
workbook or into another open one. This retains all formatting, column
widths etc.

Hope this helps.

Pete

Copy worksheet and keep all formating
 

If you have both the source and target file open you can right click on the
tab of the sheet you want to copy, selet Move or Copy, in the TO BOOK combo
select the workbook you want to copy it to, select where you want it to go in
the BEFORE SHEET list box, and then make sure you check the CREATE A COPY
check bos.. Click OK and you're done.
--
Kevin Backmann


"Pete_UK" wrote:

You can do a CTRL-drag of the worksheet tab, either into the same
workbook or into another open one. This retains all formatting, column
widths etc.

Hope this helps.

Pete