How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

I am trying to sort a large spreadsheet and am getting a this

This answer was rated:

I am trying to sort a large spreadsheet and am getting a "this operation requires the merged cells to be identically sized" message. I did not merge any cells and have never run into this problem before. How do I correct the spreadsheet so I can sort?



There must be some merged cells somewhere on that sheet. To unmerge any merged cells, select all the cells, then click Format > Cells > Alignment tab, and uncheck the box 'Merge cells' (you may need to click twice to totally remove the check). Then click OK.


Hope this helps. Let me know if you have any questions.


John D and 2 other Mac Specialists are ready to help you