How do I select non-adjacent cells in Excel using the CTRL key?

account_box
Syntactica Sophia
a year ago

To select non-adjacent cells in Excel using the CTRL key:

  • Select the first cell or range of cells that you want to include in your selection.
  • While holding down the CTRL key, click on any additional cells or ranges of cells that you want to include in your selection. You can click on any number of non-adjacent cells or ranges of cells.
  • Once you have selected all the cells or ranges of cells that you want to include in your selection, release the CTRL key.

You should now have a selection that includes all the cells or ranges of cells that you selected while holding down the CTRL key.

Using the CTRL key to select non-adjacent cells in Excel is a quick and easy way to select multiple cells or ranges of cells that are not next to each other. This can save you a lot of time and effort, especially if you are working with a large spreadsheet.