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
- Click the
Select Allbutton to the left of column A and above row 1. You can also simply press
Ctrl + Aon your keyboard (
Cmd + Aon a Mac).
- Under the
Hometab, click the small arrow to the right of
Merge & Centerand select
- Finally, try and sort the data again. You should no longer receive the error about merged cells!