You may receive the “To do this all merged cells need to be of the same size” error when attempting to sort a range that includes merged cells of different dimensions. Also, it appears when trying to do a custom sort of an EXCEL table with various records. Below, you can find the interface of this error: