How to Fix Merged Cells Must be Same Size Excel Error

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 All button to the left of A and above 1. You can also simply press Ctrl + A on your keyboard.

Excel Office 365 Select All Button

Under the Home tab, click the small arrow to the right of Merge & Center and select Unmerge Cells.

Excel Office 365 Unmerge Cells Under Home Tab

Finally, try and sort the data again. You should no longer receive the error about merged cells!

Leave a Comment