Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

25 Sep 2014   #1
gplea

Win7 64Bit Enterprise
 
 
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 System SpecsSystem Spec
.
28 Sep 2014   #2
A Guy

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium x64 SP1
 
 

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

A Guy
My System SpecsSystem Spec
28 Sep 2014   #3
gplea

Win7 64Bit Enterprise
 
 

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 System SpecsSystem Spec
.

28 Sep 2014   #4
A Guy

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium x64 SP1
 
 

Great, glad you got it sorted

A Guy
My System SpecsSystem Spec
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
A "non-existent" Windows update ("KB3024777") even Google can't find
I'm not sure what this is in Windows Update , but how is it possible to have no results in Google on this KB that's in Windows Update? I also clicked on the "more information" for the Microsoft Knowledge Base, but nothing came up there either. http://www.imagesup.net/?di=614183414306
Windows Updates & Activation
Making files in subfolders sort by "Date" or "Date Taken" by default?
(Running Windows 7 Professional x64 SP1) I'm a professional photographer and have recently begun shooting with two cameras simultaneously at events. They use different file names to avoid duplicate names/confusion, i.e. IMG_175000 and XMG_175000. Often times I'll take a photo with one camera and...
General Discussion
Google "More" and "Search Tools" buttons no longer working...
Sometime over the last few weeks Google's "More" drop-down and its "Search Tools" menu items have quit working in IE10. The other buttons that let you select web, images, shopping, etc. still work properly. The "More" and "Search Tools" buttons get focus when the mouse is over them and they...
Browsers & Mail
Resolution Error "Out of Range" 16:9 Games
Hey guys, I recently downloaded Metro 2033 on steam. It made my computer go "Out of range" even when I rebooted, So I called a technician over to fix it and I think he did a clean reinstall of the OS. It worked after that but now I can't seem to play any games and I can't go back to resolutions...
Gaming
uninstalled google docs now win search error "cant access device"
I installed google desktop for a while. Didnt like it. Unistalled thru google uninstall. Now search won't function. Get this error. Help fixing appreciated.
General Discussion
stupid "out of range error"
i keep getting out of range error/funny color weird bars on screen when playing games.. even though im runnning my games 0n 1680x1050.. sometimes thishapens only in certain level/area of a game.. what should i do??? my monitor is 1680x1050.. when i run games on lower resoultion it works but is...
Gaming


Our Sites

Site Links

About Us

Find 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 17:29.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App