Download Article
The easiest ways to select non-adjacent cells in a worksheet
Download Article
Do you need to select multiple non-adjacent cells in Excel? Selecting a range of adjacent cells is easy, as you can click and drag your cursor. Thankfully, selecting multiple non-adjacent cells is simple too. In this article, we'll teach you four easy ways to select non-adjacent Excel cells on a PC or Mac.
Things You Should Know
- The easiest way to select nonadjacent cells is to press and hold Ctrl or Cmd while clicking each cell.
- You can also select nonadjacent cells by pressing F8 to select cells and Shift + F8 to move around the spreadsheet.
- If you have a big worksheet, you can use the Name Box or Find and Replace tool to select cells that match certain criteria.
Steps
-
Click the first cell you want to select. The easiest and most efficient way to select non-adjacent cells or cell ranges in Excel is to use your mouse and keyboard. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Hold down the Ctrl (PC) or ⌘ Cmd (Mac) key. If you hold the Ctrl key (on Windows) or the Cmd key (on Mac), you can select non-adjacent cells.
- In contrast, holding down Shift only lets you select a range.
Advertisement -
Click the other cells you want to select. To select additional cells, click each cell while holding down Ctrl or Cmd .
- To select a range of cells that are not adjacent to the original cell, click and hold on the first cell in the range, then drag to select the rest of the cells. Release the mouse button when you have finished selecting your range.
- Remember to continue holding down the Ctrl or Cmd key while you click on cells to select them.
-
Release the Ctrl / ⌘ Cmd key once you're done. Note that the selection will disappear if you click any other cells while you've got your selection active.
Advertisement
-
Highlight the first cell you want to select with the arrow keys. If you want, you can use solely the keyboard to select non-adjacent cells in Excel . [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Press the F8 key. This will enable "Extend Selection" mode, and you will see it denoted in the status bar at the bottom of the window.
-
Use the arrow keys to select the cells you want selected. If you only want one cell selected, move on to the next step. Otherwise, use the up, down, left, and right arrows to make your selection.
-
Press ⇧ Shift + F8 to stop selecting. The cells you selected will remain selected, and you will notice that you're in "Add or Remove Selection" mode.
-
Use the arrow keys to highlight the next cell you want to select. You can also use the mouse to click the next cell if you prefer, though you can use the arrow keys if you're trying to only use the keyboard.
-
Repeat steps 2 through 4 until you've selected the needed cells. Continue alternating between "Extend Selection" mode and "Add or Remove Selection" mode until you're done.
-
Press F8 again. This will disable "Extend Selection" mode. Note that the selection will disappear if you click any other cells while you've got your selection active.
Advertisement
-
Click on the blank white box directly to the left of the formula bar . This is the Name Box, and typing the name of a cell in this box will highlight it. This method works well if you've got a large sheet with a lot of cells filled in. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Type the cell names or ranges separated by commas. You could write, for example, A1, C1, E1 to select single cells, or A1:A10, C1:C10, E1:E10 to select a range of cells.
-
Press ↵ Enter . All of the cells you entered in the Name Box will be selected, with the last specified cell being the active cell. Note that if you click any other cells while you've got your selection active, the selection will disappear.
Advertisement
-
Press Ctrl + A (PC) or ⌘ Cmd + A (Mac). To select the worksheet, you can press Ctrl + A on Windows or Cmd + A on Mac. Another way of selecting non-adjacent tiles, especially those that hold specific data, is to use the Find and Replace tool. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Press Ctrl + F / ⌘ Cmd + F . On Windows, press Ctrl + F and on Mac, press Cmd + F . This will open the Find and Replace tool.
-
Enter some data in the "Find what:" field. For example, if your spreadsheet has a list of names in it and you want to select all the cells with the last name "Johnson" in them, you would enter "Johnson" in the "Find what:" field.
-
Click Find All . All cells containing what you searched for will show up in the Find and Replace window.
-
Press Ctrl + A / ⌘ Cmd + A . To select all of the found cells, you can press Ctrl + A on Windows or Cmd + A on Mac.
-
Close the Find and Replace window. All cells containing the info you searched for will be selected. Note that if you click any other cells while you've got your selection active, the selection will disappear.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- If you want to make a change to the cell value of your selected non-adjacent cells, enter the new cell value in the active cell and press Ctrl + ↵ Enter on Windows or ⌘ Cmd + ↵ Enter on Mac.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
References
- ↑ https://support.microsoft.com/en-gb/office/select-cell-contents-in-excel-23f64223-2b6b-453a-8688-248355f10fa9
- ↑ https://support.microsoft.com/en-gb/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f
- ↑ https://support.microsoft.com/en-au/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
- ↑ https://support.microsoft.com/en-au/office/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90
About This Article
Thanks to all authors for creating a page that has been read 4,727 times.
Advertisement