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.

But how do you past? (ctrl+v doesn't work on edge) – JinSnow Mar 22 '20 at 12:45 — JinSnow, Mar 22 '20 at 12:45

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

21.8k11 gold badges75 silver badges98 bronze badges

answered Jun 28 '12 at 15:38

Random Guy

7654 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 |