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

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