Method 6 – Select Rows or Columns of Cells in Excel You can easily select single or multiple rows of cells by selecting the row numbers at the left of each row. To select non-adjacent rows, hold the CTRL key and then select the desired rows. You can use the column numbers at the ...
Method 1 – Select a Range of Adjacent Cells in an Excel Formula Suppose we want to sum up the sales amounts for the month of January. Specifically, we want to sum the adjacent cells in the range C5:C9. Here’s how we can achieve this using the Excel SUM formula: Enter the SUM fu...
This Excel shortcut selects an entire column or columns. PC Shortcut:Ctrl+Space Mac Shortcut:⌃+space See All Excel Shortcuts In this Article Excel Shortcuts to Select Rows and Columns Select Entire Row Select Entire Column Select Adjacent Cells Select Non-Adjacent Cells Select Non-Adjacent ...
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 postHow do I stop Excel from highlighting two cells at once?in the community.
Select Non-Adjacent Cells/Ranges Using the Name Box Sometimes, you need to select specific cells that are scattered and far off. In such a case, you can also use theName Box in Excelto select non-adjacent cells. Name Box is right next to the formula bar (on the left of it) and is...
The Microsoft Excel'sGo tocommand can help you select non-adjacent cells or ranges quickly with following steps: 1. Click theHome>Find & Select>Go to(or press theF5key). 2. In theGo Todialog box, enter the cell/range positions in theReferencebox, and click lick theOKbutton. ...
ASAP Utilities »Select › 7 Select adjacent cells below active cell with the same value: This utility will expand your selection to include all adjacent cells which have the same value below your active cell. - ASAP Utilities, description of our E
Step 4: After selecting the range, then click OK, and all the data cells including formulas in the range has been selected.Related articles: Select non-adjacent cells or ranges Deselect cells from selected ranges Reverse selections of selected rangesBest Office Productivity Tools 🤖 Kutools AI ...
Hold Ctrl while selecting the column headings of the non-adjacent columns or the row numbers of the non-adjacent rows. For example, hold Ctrl and selectA,C,E,G,H,I,K. Other ways to select cell contents To select a list, select any cell in that list, and then press Ctrl + A. ...
Keyboard Shortcuts for Basic Column Selection in Excel The row you've chosen will become highlighted in grey, signifying its selection. If you want to select multiple consecutive rows, follow the process given below. Step 4:Select multiple cells in a column adjacent to each other and press “...