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.

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