Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. Is it possible somehow?

share|improve this question

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

share|improve this answer
So... Stupid... :/ Thanks for the answer, though! – Lemmings19 Dec 11 '12 at 8:15
Nowadays, this answer is obsolete. See webapps.stackexchange.com/a/56873/88163 – Rubén Jan 5 at 16:26


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


enter image description here


This is only possible with the new Google Spreadsheets.


share|improve this answer

protected by Community Jan 29 '13 at 20:13

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.