Try copying and "Paste Special" (by right clicking on a cell in the new
worksheet and selecting 'paste special').
In the Paste Special window select "Format" and "OK" to apply it.
All your formats should be preserved.


"hsyrddy" wrote:

When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do
not remain the same as the original format which causes us to have to
manually resize the new worksheet to match the existing one. Does anyone have
a solution? thanks