One of the biggest concerns we’ve heard about Google Spreadsheets is that it lacks a lot of the basic features contained in Microsoft Excel. While many of these features can be replicated with workarounds, one major problem (with no real solution) was the inability to select multiple, non-adjacent cells. Many of you will be happy to know that Google quietly announced an update to the new Google Sheets that finally allows you to do this.

Select non-adjacent cells in Google Spreadsheets

For those of you who aren’t power-spreadsheet users, it may not seem like a big deal to be able to select multiple cells at once. But for those of  you who spend a lot of time working with spreadsheets, you know how valuable this update is. For example, formatting in Google Spreadsheets can be a little time consuming if you have to apply the changes to one group of cells, then apply the exact same changes to another group. With this update you can cut out that second step entirely, which can save a ton of time in the long run.

To select non-adjacent cells, simply hold down the command key (for Mac users, PC users hold down the CTRL key) while making your selections. Keep in mind this update is only available in the new Google Sheets, so consider this a great reason to upgrade your account. To upgrade to the new Google Sheets, click on the settings gear inside Google Drive and click settings. From there you’ll need to select the ‘Editing’ tab and then enable the new Sheets. This won’t upgrade your previously created Sheets, but every new Sheet will be in this new format.


The #1 resource for Google Apps how-to videos. Follow The Gooru to keep up to date on the latest Google Apps features, news, updates and more! You can also check out The Gooru's library of Google Drive Training videos and Gmail Training videos!



    1. The Gooru


      Do you mean the new Sheets aren’t available for Google Apps for Business? I don’t believe that is the case, I’m on a Google Apps for Business account and I have access to the new Sheets…

  1. Nestor Albuquerque

    Although I’ve enabled it in the personal ( account, it is not working … do I have to wait for some distribution still to come?

    And what about the Google Apps (corporate, Standard plan) account? It doesn’t even allow that check…


    1. The Gooru

      It may not have rolled out to Gmail users and it’s possible your Google Apps Administrator has disabled experimental features in the Admin Console.

  2. Morgan

    Yes but you can’t copy the cells once you’ve selected them. Only delete them. This basically defeats the purpose of having such a feature. If you’re reading this you may even think I must be wrong. No. Not a joke. Someone implemented a multi-select feature upgrade but decided to leave out copy functionality. Dire.

Leave a Reply

Your email address will not be published. Required fields are marked *