This accuse will demonstrate how to choose non-adjacent cell or columns in Excel & Google Sheets.

You are watching: How to select non adjacent cells in excel


Occasionally we may wish to layout or delete the materials of cell or columns that are not beside each other. The is more efficient to pick all this cells at once.

Select Non-Adjacent cells or Columns with the Keyboard

The regulate Key

1. Pick the very first column or range of cells that space required.

2. Hold down the CTRL key on the keyboard and also select the 2nd range of cells required.

3. Keep holding down the CTRL an essential while selecting all the forced ranges through dragging the mouse or using the arrows ~ above the keyboard.


4. We can then format or delete the components of the cells, as required.

Shift F8 – add to Selection

1. By pressing SHIFT + F8 ~ above the keyboard, you placed Excel right into Add to Selection mode.

2. A message will be displayed on the status bar in the bottom left hand corner of the Excel screen.


3. V this mode you can pick non-adjacent cells and columns by simply choosing them with the mouse.

Select Non-Adjacent cell or Columns utilizing Go To

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


Alternatively, push F5 or CTRL + G ~ above the keyboard.

2. In the Reference box, type in the selection of cells that you great to select. Each range needs to have actually the cell addresses be separated by a colon (:) and then each variety of cell separated through a comma (,).


3. Click OK to highlight the selection of cells.


The arrays of cells perform not must match. Us can select 10 cell in one column and also 5 cells in an additional if this is required.


We can also select a heat of cells and also a shaft of cell together.

See more: Which Sentence Needs A Semicolon Added To Be Correct ? A (5) Water Is Not Everywhere It'S Miles Away


Select Non-Adjacent cell or Columns through Google Sheets

Holding under the CTRL vital on the keyboard and also dragging end the compelled cells through the computer mouse is the only way that non-adjacent columns and cells have the right to be selected in Google Sheets.