How do you select non adjacent cells in excel

Excel offers a very interesting way to select non adjacent cells. We can cater to this problem statement by using the CTRL key on the keyboard. We can perform the below mentioned way to select non adjacent cells in excel:

We’ll learn about this methodology step by step.

How do you select non adjacent cells in excel:

Step-1: Excel workbook opened

To do this yourself, please follow the steps described below;

– Open the desired Excel workbook where you need to select non adjacent cells

Step-2: Making the required cell active

– Now select any of the required cells from where we need to select multiple non adjacent cells.

Final Image : Using the CTRL key

– Now press the CTRL key on the keyboard, and then with your mouse click on the required non adjacent cells which need to be selected.