How to select multiple cells in Google Sheets

Google-sheets How easily to select multiple cells in Google Sheets

google sheets

Best Answer

Adjacent

As of 11-02-2014, it is possible to select multiple cells, even the ones that aren't adjacent and perform different actions like:

• Styling
• Delete values
• Undo/redo actions
• Paste values (into all cells)
• Apply a quick sum
• Work with formulas and charts

Screenshot

Note

This is only possible with the new Google Spreadsheets.

References

• https://productforums.google.com/d/msg/docs/TUltIeMntog/2EfOq_f01lEJ
• https://support.google.com/drive/answer/46973?hl=en
• http://googledrive.blogspot.nl/2013/12/newsheets.html

• Google-sheets Fill value in multiple cells in Google Sheets
• Google-sheets How to Fill a Column with Sequential Dates in Google Sheets
• Google-sheets How to protect table cells in Google Sheets from theself (accidental edits)
• Google-sheets I would like to select one cell and highlight different cells in the same Google Sheets
• Google-sheets How to select multiple rows in Google Sheets and do a sort
• Google-sheets Delete multiple sheet tabs in Google Sheets
• Google-sheets How to select multiple columns using Google Sheets =CHOOSE() function