View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you're using xl2k or higher, you can copy column widths by selecting the
columns, then selecting the "to" range and
edit|paste special
and click on column widths.

If you're using xl97, you can copy all the columns' formatting (including
columnwidths) by copying the column, then selecting selecting the "to" range and
edit|paste special|formats

Sunantoro wrote:

it is sometime required to copy width of several colums to the right. Is
there any way to do it in one step? Thanks


--

Dave Peterson