Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

2 Answers 2

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


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 answers, posting an answer now requires 10 reputation on this site.

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.