Take the 2-minute tour ×
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
add comment

2 Answers

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
add comment

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
add comment

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.