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

  1. Click the Select All button to the left of column A and above row 1. You can also simply press Ctrl + A on your keyboard (Cmd + A on a Mac).
    Excel Office 365 Select All Button
  2. 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
  3. Finally, try and sort the data again. You should no longer receive the error about merged cells!

9 thoughts on “How to Fix Merged Cells Must be Same Size Excel Error”

  1. Thank you so much for these instructions. We had a client that was having this issue and she reached out to our team for assistance. Grateful that I came across your instructions as we were able to get the issue resolved for the client in no time. Thanks again!

  2. So I selected unmerged cells but when I went back and hi-lighted the column and sort A-Z, I still received same error on merged cells need to be the same size.

  3. OMG!!!!! i have been trying to figure this out for tooooo long. I was trying to filter my date by column and it kept saying all merged cells need to be same size. i was lost and about to hand type all my data over on a new sheet. This out of like 10 sites i clicked on really worked. Ya’ll are amazing.


Leave a Comment