But both of these methods work when you want to select a contiguous range of cells. But what if you want toselect non-adjacent cells in Excel? You can do that too… it’s not as easy as selecting the adjacent cells, but it’s still quite easy. ...
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. ...
Also read: Flip Data in Excel | Reverse Order of Data in Column/Row Swapping Non-Adjacent Cells In this above example, I’ve shown you how to swap two contiguous cells. You can also use this to swap to nonadjacent cells. However, you would have to repeat this process twice. For exa...
Select Adjacent Cells Say you want to select cells A1:C6. To do that, place the cursor on the first cell of the range (A1) and drag the cursor till the last cell (C6). This selects all the cells between A1 and C6. Select Non-Adjacent Cells To select multiple non-adjacent cells (...
Click and drag your mouse over the row numbers to select the specific hidden rows that you want to unhide. Alternatively, you can hold down the "Ctrl" key and click on individual row numbers to select non-adjacent hidden rows. Unhide specific Rows in Excel ...
2. Select cells, ranges, columns or rows you want to protect To lockcells or ranges, select them in a usual way by using the mouse or arrow keys in combination with Shift. To selectnon-adjacentcells, select the first cell or a range of cells, press and hold theCtrlkey, and select ot...
Method 1 – Select All Cells with Values Using the ‘Go To Special’ Command The dataset below has data on several areas of fruit sales date-wise. However, it has some blank cells. We will select all the non-contiguous cells with data using Excel’s ‘Go To Special’ command. This ...
Note:This method cannot be used toselect non-adjacent cells. It works only for selecting adjacent cells. Read More:How Do I Quickly Select Thousands of Rows in Excel (2 Ways) Method 3 – Selecting Entire Rows Left-clickon the number of theRowyou want to select. All the cells in thatRo...
Step1: Select the range that you want to select only the data cells. Step2: Click Kutools > Select > Select Nonblank Cells, and then all the cells with data have been selected at once, see screenshot:Free Download Kutools for Excel Now Select all cells with data including formulas with ...
Keyboard shortcut. To streamline your workflow even further, you can use keyboard shortcut. Select several adjacent cells in one row and press theCtrl + Spacekeys simultaneously to select the entire columns. Tip.When you want tofreeze selected rows, keep in mind that Microsoft Excel allows free...