Hi, Daniel. Likely, you need to select all the cells, then Format--Cells,
Alignment tab and uncheck the merge cells box. After that, you can
troubleshoot any other issues. See:
http://www.officearticles.com/excel/...soft_excel.htm
if it still won't sort right.

--
~Anne Troy
www.OfficeArticles.com


"Daniel" wrote:

I copied and pasted into excel the data that has rows and columns from web
page display in IE6. In excel I tried to sort by a column and I am getting
the display that says, "This operation requires the merged cells to be
identically sized." I noticed that I cannot expand a column to different
size. When I expand a column all the other columns expand to same size. How
can I sort by a column and expand columns in different size?

Thanks for your help.