View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hon123456
 
Posts: n/a
Default How to autosize the cell when copying

Dear all,
When I try to copy a range of cells and paste to another
range in the same sheet, the cell that
being patsted do not have the same width and height of the original
cell. I need to adjust the cell width and height one by one. Is there
any mothod to let the pasted cell have the same width and height as the
original cells without adjusting the width manully?

Thanks.