Select Non-Adjacent Cells / Columns in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on December 26, 2022

This tutorial demonstrates how to select non-adjacent cells or columns in Excel and Google Sheets.


non adjacent intro


Occasionally you may wish to format or delete the contents of cells or columns that are not next to each other. It is more efficient to select all these cells at once.

Select Non-Adjacent Cells or Columns With the Keyboard

The Control Key

  1. Select the first column or range of cells.
  2. Hold down the CTRL key on the keyboard and select the second range of cells.
  3. Keep holding down the CTRL key while selecting all the required ranges by dragging the mouse or using the arrows on the keyboard.


non adjacent control select


  1. You can then format or delete the contents of the cells, as needed.

Shift F8 – Add to Selection

  1. By pressing SHIFT + F8 on the keyboard, you put Excel into Add to Selection mode.
  2. A message is shown on the status bar in the bottom left-hand corner of the Excel screen.


non adjacent add to selection


  1. With this mode you can select non-adjacent cells and columns by simply selecting them with the mouse.

Select Non-Adjacent Cells or Columns Using Go To

  1. In the Ribbon, select Home > Find & Select > Go To.

non adjacent ribbon goto


Alternatively, press CTRL + G on the keyboard.

  1. In the Reference box, type in the range of cells you wish to select. Each range needs to have the cell addresses separated by a colon (:) and then each range of cells separated by a comma (,).


non adjacent ribbon goto range


  1. Click OK to highlight the range of cells.


non adjacent ribbon goto selected


The ranges of cells do not need to match. You can select ten cells in one column and five cells in another if needed.


non adjacent different rows


You can also select a row of cells and a column of cells together.


non adjacent goto row column


Select Non-Adjacent Cells in Google Sheets

Holding down the CTRL key on the keyboard and dragging over the required cells with the mouse is the only way that non-adjacent columns and cells can be selected in Google Sheets.


non adjacent google sheets

AI Formula Generator

Try for Free

See all How-To Articles