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

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

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

enter image description here

Note

This is only possible with the new Google Spreadsheets.

References

share|improve this answer

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

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.

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.