When trying to sort data in Excel, you may have encountered an error indicating that merged cells must be the same size. This usually happens when you copy and paste data from a source to Excel. Sometimes, this forces excel to merge some cells without you even noticing.
To fix this issue, you simply need to unmerge all cells in the sheet. That sounds like a lot of work, but it can actually be done with only a few clicks – here’s how.
How to Fix Merged Cells Need to be the Same Size Error in Excel
Select All button to the left of A and above 1. You can also simply press
Ctrl + A on your keyboard.
Home tab, click the small arrow to the right of
Merge & Center and select
Finally, try and sort the data again. You should no longer receive the error about merged cells!