Non-adjacent cells are those cells in Excel that are not next to each other. For example, if you have a list of data in columns A, B, and C, the cells in column A are not adjacent to those in column C. To select non-adjacent cells, you need to hold down the CTRL key while you click on the cells you want to select.
Here we show 4 techniques for selecting Non-Adjacent Cells in excel.
- Select Non-Adjacent Cells With Keyboard.
- Select Non-Adjacent Cells With Keyboard and Mouse.
- Select Non-Adjacent Cells With Command.
- Select Non-Adjacent Cells With Kutools.
Let’s get to know all those techniques with examples.
Contents
1. Select Non-Adjacent Cells With Keyboard
To select non-adjacent cells in Excel, click on the cell you want to select. Then, select multiple, non-adjacent cells using only the keyboard, and follow these steps:
- After selecting the first cell, press the F8 key to activate the ‘Extend Selection.
- Select your adjacent cells by using the arrow key.
- Hold Shift and press F8 to deactivate the ‘Extend Selection. And here also active the’ Add or Remove Selection.’
- Press F8 again before making a selection.
- After selecting a cell, hold Shift and press F8 to remove the ‘Extend Selection.
- By continuing this process, you can select multiple cells in excel.
2. Select Non-Adjacent Cells With Keyboard and Mouse
To select non-adjacent cells with the keyboard and mouse:
- Select the cell you want to start with by clicking on it.
- Hold down the Ctrl key on your keyboard and click on the other cells you want to select.
- Release the Ctrl key, highlighting all your selected cells.
3. Select Non-Adjacent Cells With Command
To select non-adjacent cells with the command key, follow these steps:
Step 1: Go to your home tab on the excel sheet and click Find & Select option. Then select the Go To option.
Step 2: Here, open a Go To window. You also open the window by pressing the F5 key. In the Reference box, you must put on the range of cells and click ok.
Step 3: Here is the result.
4. Select Non-Adjacent Cells With Kutools
With Kutools for Excel, you can quickly select non-adjacent cells with a certain value or select cells based on certain criteria. This is a great time-saving tool when you need to select data in a large worksheet.
First, you click the Kutools and click the Select options. Then click to the select range helper.
Open the Select Range Helper option and select Union Selection. Next, you have to select your cells and click the close button.
Conclusion
The easiest way to select non-adjacent cells in Excel, click on the cell you want to select. Then, hold down the Control key and click on the other cells you want to select. Finally, release the Control key to complete the Selection. But we also have alternative ways to do this job. Hope you will do all the steps successfully.
