Question

How to select non-contiguous cells in excel?​

Answer 1

Click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.

ꁝꄲꉣꏂ ꒐꓄ ꁝꏂ꒒ꉣꇙ........ :-)

Answer 2

• Click on a cell to select it. Or use the keyboard to navigate to it and select it.

• To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.

• Or use the Shift + arrow keys to select the range.

• To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Hope this helps you ✌️