When you copy an entire worksheet, it should preserve columns width. If
you're manually copying sections of the worksheet over, when you go to paste,
right-click select paste special, and select column width. Then you
immediately do a regular paste on top on that.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ian" wrote:

I know how to copy a worksheet to make a new worksheet but can anyone tell me
how to copy a worksheet so that when it is copied across the column widths
and row heights are excatly the same as the original.

It is becoming a pain that after copying it I have to go through the whole
of the new worksheet(s) changing column widths and row heights to the
original widths and heights.