Ask Mac Questions and Get Answers from Experts ASAP
Select the range of data that your want to sort (or the columns), then from the menu click Format > Cells > Alignment tab, then completely uncheck the box 'Merge cells'. Click OK
You should be able to sort now
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the answer
No you need to click on it until the box is completely blank.
Please select the range again then go to the alignment tab and keep clicking on the box until it is completely blank
If the file has sensitive information let me know before you upload it
Here you go
There were still some merged cells in the header. I unmerged them and everything should be ok now
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
Were you able to download the file?
You're welcome. Glad to help