Forum Discussion
Sorting data in columns with merged cells same size
I had to copy values from a vector file (corel draw .cdr) by copy and paste to a blank excel sheet. Problem is one of the cell columns contain a picture. I tried to group each roll and make the picture same size for each row but I'm getting a message about merged cells need to be the same size. All I'm trying to do is sort the first column with the respective data in the other columns/rows and I am dumbfounded. Any suggestions?
1 Reply
Take this:
1. Unmerge All Cells
• Select the entire range.
• Go to Home > Merge & Center > Unmerge Cells.
• This removes the structural conflict that prevents sorting.
2. Anchor Images to Cells
• Right-click each image > Format Picture.
• Under Properties, choose Move and size with cells.
• Resize each image manually to match the row height if needed.
3. Sort Your Data
• Select your full table.
• Go to Data > Sort.
• Choose the column you want to sort by (e.g., Column A).
4. Re-merge if Needed
• After sorting, you can re-merge cells for visual formatting.
• But consider alternatives like Center Across Selection (under Alignment settings), which looks like merging but doesn’t break sorting.
