 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007excel sort problem
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. 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/data_cleanup_tips_for_microsoft_excel.htm if it still won't sort right.  Signature~Anne Troy www.OfficeArticles.com > 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 [quoted text clipped - 4 lines] > > Thanks for your help. > 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 [quoted text clipped - 10 lines] > > > > Thanks for your help. Thank You Anne and Daniel. You saved me alot of time and frustration by your willingness to share your knowledge. Armando > 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 [quoted text clipped - 10 lines] > > > > Thanks for your help. 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 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. > 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 [quoted text clipped - 4 lines] > > Thanks for your help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.