It’s easy to select nonadjacent cells in Excel, but it might not be easy for you to figure out how to do so. There are many different ways to perform this. It depends on what the situation calls for.

For example, you might want to select nonadjacent cells if you want to copy and paste them to all of the cells. Selecting a single cell in a spreadsheet can be a challenging task.

Sometimes you end up selecting a cell that is not even near to the cell you wanted. Selecting nonadjacent cells in excel might seem like a tough job but it can be done.

In this blog, we will look at how to select non adjacent cells in excel?

Select Non-Adjacent Cells with Keyboard and Mouse

If you’re a keyboard person, there’s also a way to use your keyboard to select cells that aren’t immediately adjacent to each other.

The Double-Click method makes it possible for you to only have to click once and then click a second time on another number or an empty cell space, which will automatically select a group of contiguous cells.

Lower the Extend Selection mode that you press “Ctrl” + double-click on the first cell that you want to be selected and then press “Ctrl” + double-click another cell without entering data.

Now you have to use the arrows keys for selection. In the Extend Selection mode, it will only select adjacent regions of cells.

Now press Shift+F8 to disable multiple selection modes and enable extended selection mode. Ctrl-Shift-Click on a highlighted cell set the range of selected cells from all currently selected ranges.

Use the arrow keys to go to the next cell that you want to select. Next, press F8 again and use the arrow keys to make the selection.

Then, toggle off (use Shift+F8) multiple selection mode and use arrow keys to move down to the next cell that you want to select. Using F8 toggles Selection Mode & enables you to select individual cells.

If you toggle selection mode again by using Shift + F8, your cell selections will then move or be dropped one row down/across.

When the ‘Select Adjacent Cells’ option is enabled, you can use your mouse click to select non-containing dots.

Selecting Non-Adjacent Cells Using the Name Box

The Name box is located to the left of the formula bar which normally displays the address of the active cell or group of cells in a worksheet. You can also use the Name box to select non-contiguous cells by using Control-Click.

For example, let’s assume that you want to highlight A5, B2:B10, D5, D7, E2, and E10. To accomplish this task:

It’s possible to insert a named range in the formula based on the highlighted cell or range. There are several ways to do it.

You can type the references into the Name Box, select them from the drop-down list with the mouse, or – more advanced option – type/select formulas using F2 with no visible cells selected.

When you highlight cells your Name Box changes so you now see what is being used as a name, i.e. B1, etc, very useful.

FAQs Related How to Select Non Adjacent Cells in Excel?

How do you select a range of cells in Excel?

Type the cell’s address into the Go to Reference box. Start typing a range or a specific cell, and Excel will display a list of matching cells in the Go To dialog box.

Then press Enter to finally launch your selection. How cool is that? And if you’re looking for a shortcut way to automatically type formulas with cell references as easy as pie, check out Keyboard Shortcuts.

With this Add-in for Excel, you can now easily set hotkeys for those time-saving keyboard shortcuts.

What is the fastest way to select data in Excel?

1. Shift + Arrow Keys – Increases the highlighted range in the direction of the arrow key.
2. Shift + Spacebar- It will help you to select the rows of the highlighted range or entire row.
3. Ctrl + Spacebar – Selects the entire column or columns of the highlighted range.

What is a shortcut way to add non-adjacent cells to selection?

Hold the Control key (CTRL) and click on another range of calls or hold CTRL and drag to select another range.

Conclusion

If you are a regular user of excel, you might have come across a situation where you need to select nonadjacent cells.

In such a case, you have to use a combination of shift and arrow keys to reach your destination cell. But what if there is a quicker solution to the same? Yes, you guessed it correctly.

In this article, I will explain a better and quicker solution to this problem. You can easily select the non-adjacent cells by using different ways.

You can select them by using the keyboard or by using a mouse. There are also many shortcut ways to do this.

I hope that you will understand that how to select non adjacent cells in excel. If you have any further queries regarding this, then tell us in the comment section or visit our website.