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?

6

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

1
  • But how do you past? (ctrl+v doesn't work on edge) – JinSnow Mar 22 '20 at 12:45
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.

2

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