Forum Discussion
Sorting rows that contains both merged columns and non merged columns
Hello all, I am trying to sort a selection of rows that contains both merged columns and non merged columns. Excel gives me an error msg stating the merged cells must be the same size. Is ther...
No. You cannot filter or sort properly with merged cells. It also breaks tables, Insights, and Get & Transform Data.
Remove all merges before doing that kind of operation. Most merges can be done away with and just use Center Across Selection, which would just center data across multiple cells, but not merge them.
Merging cells is good for one thing. Making something look like a PDF form. It wreaks havoc though when trying to do any sort of analysis. I have a macro in my personal.xlsb workbook that automatically removes all merged cells for any workbooks I have to do work on.