excel sort problem

D

Daniel

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.
 
D

Deena

Daniel, Anne is right but not specific enough. There is a cell that is merged
within your spreadsheet and you can't have any merged items in order to sort.
After you have corrected your merge problem, highlight the spreadsheet and
sort it like you want it.
 
A

Armando

Thank You Anne and Daniel.

You saved me alot of time and frustration by your willingness
to share your knowledge.

Armando
 
G

grateful person

thank you from me as well! i've been struggling with this problem for it seems like hours, then found your solution by googling the problem. your answers were much more helpful than the one offered by microsoft. thanks again.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top