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


  1. Posts : 135
    Win7 64Bit Enterprise
       #1

    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.

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


  2. Posts : 53,660
    Windows 10 Home x64
       #2

    try selecting all cells, then click Format > Merge cells > Unmerge
    https://productforums.google.com/for...cs/b1B5ZswXytE

    A Guy
      My Computer


  3. Posts : 135
    Win7 64Bit Enterprise
    Thread Starter
       #3

    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
      My Computer


  4. Posts : 53,660
    Windows 10 Home x64
       #4

    Great, glad you got it sorted

    A Guy
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 06:33.
Find Us