7

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?

5

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

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.

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.