1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Select Non-Adjacent Cells in Excel with Keyboard and Mouse

Excel Shortcut Keys: Select Non-Adjacent Cells


Select Non-adjacent Cells in Excel

Select Non-adjacent Cells in Excel

© Ted French

Related Tutorial: Selecting Non-Adjacent Cells Using the Keyboard

By selecting multiple cells in Excel you can delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet all at one time.

While using the drag select method with the mouse to quickly highlight a block of adjacent cells is probably the most common way of selecting more than one cell, there are times when the cells you want to highlight are not located beside each other.

When this occurs, it is possible to select non-adjacent cells. Although selecting non-adjacent cells can be done solely with the keyboard, it is easier to do using the keyboard and mouse together.

Selecting Non-Adjacent Cells in Excel

For help with this example, see the image above.

  1. Click on the first cell you want to select with the mouse pointer to make it the active cell.

  2. Release the mouse button.

  3. Press and hold down the Ctrl key on the keyboard.

  4. Click on the rest of the cells you want to select them Without releasing the Ctrl key.

  5. Once all the desired cells are selected, release the Ctrl key.

  6. Do Not click anywhere else with the mouse pointer once you release the Ctrl key or you will clear the highlight from the selected cells.

  7. If you release the Ctrl key too soon and wish to highlight more cells, simply press and hold down the Ctrl key again and then click on the additional cell(s).

Other Shortcut Keys Tutorials

©2014 About.com. All rights reserved.