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
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
Easy to follow
Didn't match my screen
Not sufficient information
Not sufficient pictures
Any additional feedback? (Optional)
Thank girlfriend for your feedback!
English (United States) © jajalger2018.org 2021