Solved Error Msg "Cannot sort a range containing merges." in Google Sheets

[gplea]

Error Msg "Cannot sort a range containing merges." in Google Sheets

Using Google Sheets. Why am I getting this error msg? "Cannot sort a range containing merges." I DON'T have any merged columns, or merged anything. No hidden columns, or at least they weren't hidden when I tried to do the sort.:huh:

I tried to attach the file as a XLSX, and CSV, and both formats gave me an error.

 

[A Guy]

try selecting all cells, then click Format > Merge cells > Unmerge

https://productforums.google.com/forum/#!topic/docs/b1B5ZswXytE

A Guy

 

[gplea]

Thanks A Guy (BTW, like the moniker), I fixed the issue. The problem was that I wasn't aware that the last column on the right was merged with all of the columns to the right of that. Unmerged, and fixed it.

Thanks,
GPLea

 

[A Guy]

Great, glad you got it sorted

A Guy