Excel for jajalger2018.org 365 Excel for jajalger2018.org 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel for Mac 2011 Excel Starter 2010 More...Less

Note: If a worksheet has been protected, you might not be able to select cells or their contents on a worksheet.

You are watching: Select non adjacent cells in excel

Select one or more cells

Click on a cell to select it. Or use the keyboard to navigate to it and select it.

To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.

Or use the Shift + arrow keys to select the range.

To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Select one or more rows and columns

Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.

Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.

To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.

Select table, list or worksheet

To select a list or table, select a cell in the list or table and press Ctrl + A.

To select the entire worksheet, click the Select All button at the top left corner.


Note: In some cases, selecting a cell may result in the selection of multiple adjacent cells as well. For tips on how to resolve this issue, see this post How do I stop Excel from highlighting two cells at once? in the community.

See more: What Does A Woman Feel When A Man Touches Her Breasts, What Does It Mean When A Guy Touches

Need more help?

You can always ask an expert in the Excel Tech Community or get jajalger2018.org in the Answers community.

Select specific cells or ranges

Add or remove table rows and columns in an Excel table

Move or copy rows and columns

Transpose (rotate) data from rows to columns or vice versa

Freeze panes to lock rows and columns

Lock or unlock specific areas of a protected worksheet


Need more help?

Expand your skills
Explore Training
Get new features first
Join jajalger2018.org Insiders

A subscription to make the most of your time
Try one month free

Was this information helpful?

Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Any additional feedback? (Optional)
Submit feedback

Thank you for your feedback!

What's new
jajalger2018.org Store
English (United States) © jajalger2018.org 2021