How easily to select multiple cells in Google Sheets?

Question

How do I select multiple cells in Google Sheets (non related cells, other cells between them)?

In MS Excel I just press Ctrl and click on all the cells, in Google Sheets it doesn't work.

Is it possible somehow?

Jacob Jan Tuinstra · Accepted Answer · 2014-02-12 08:13:08Z

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:

enter image description here

This is only possible with the new Google Spreadsheets.

Alex · Accepted Answer · 2012-10-02 08:50:07Z

4

In Google Docs spreadsheets it is only possible to select a single cell or ranges of adjacent cells. So in short NO, you cannot.

Alex

20.7k10 gold badges68 silver badges94 bronze badges

answered Jun 28 '12 at 15:38

Random Guy

7504 silver badges12 bronze badges

1

So... Stupid... :/ Thanks for the answer, though! – Lemmings19 Dec 11 '12 at 8:15
2

Nowadays, this answer is obsolete. See webapps.stackexchange.com/a/56873/88163 – Rubén Jan 5 '16 at 16:26

add a comment |