Sorting and Merged Cell Issues

horadav -  
 Anonymous user -
Hello,

I'm trying to sort Excel files (where the data has been copied and pasted from an intranet) but I can't because Excel says, "This operation requires that merged cells be of the same size."

My question is: how can I sort? I can't identify which cells are merged, nor how to unmerge them...

Thank you in advance
Configuration: Windows XP / Chrome 25.0.1364.172

3 answers

  1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    In Excel 2010

    right-click on the box above the row numbers (sheet selection)
    in the context menu
    Format Cells
    Alignment
    uncheck the box next to Merge Cells
    4