Merged cells break sorting and tables—use a macro to apply Center Across Selection with one click instead.
If you are unable to sort data in Excel due to the “All the merged cells need to be the same size” error, use the solutions provided in this article. It is clear ...