Hi Gord,
your right, I am try copy range of rows and columns in the first wordsheet,
the information is in defferent columns width, after pasted it can not
display all. because the columns widths is smaller then the one copy from. I
gust there no way to do it. if anyone know how. pls help!!!

"Gord Dibben" wrote:

You can apply multiple formats to any part of a column or range.

What you cannot do is have different widths for the same column if that's what
you're looking for.


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 11:15:03 -0800, John wrote:

the problem is I combim two document, copy from sheet 2 information to sheet
1. after I pasted in sheet 1, the columns format is different. is there
anyway to display two kind of columns format in same worksheet.