Excel because that 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 because that Mac Excel 2013 Excel 2010 Excel because that Mac 2011 Excel Starter 2010 More...Less

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

You are watching: Select non adjacent cells in excel

Select one or more cells

Click on a cabinet to pick it. Or use the key-board to navigate come it and select it.

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

Or usage the transition + arrow keys to select the range.

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

Select one or an ext rows and also columns

Select the letter in ~ the peak to select the entire column. Or click on any cell in the column and also then push Ctrl + Space.

Select the heat number to choose the entire row. Or click on any cell in the row and then press transition + Space.

To choose non-adjacent rows or columns, hold Ctrl and select the heat or shaft numbers.

Select table, perform or worksheet

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

To choose the entire worksheet, click the Select All button at the height left corner.


Note: In some cases, selecting a cabinet may an outcome in the selection of multiple surrounding cells as well. Because that tips on exactly how to fix this issue, view this article How perform I prevent Excel native highlighting 2 cells in ~ 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 skilled in the Excel technology Community or get jajalger2018.org in the answer community.

Select certain cells or ranges

Add or remove table rows and also columns in one Excel table

Move or copy rows and also columns

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

Freeze panes come lock rows and columns

Lock or unlock particular areas that 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 much more feedback? (The much more you tell united state the more we deserve to help.)Can you help us improve? (The more you tell us the more we deserve to help.)
What influenced your experience?
Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not sufficient information
Not sufficient pictures
Any additional feedback? (Optional)
Submit feedback

Thank girlfriend for your feedback!

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