How to Select Non Adjacent Cells in Excel
Quick google search leads me to believe this functionatliy may not be. To select a column click on the first cell from where you want to start the selection and press SHIFTCTRL down arrow key on your keyboard to select the column till the bottom like this- March Column Selected. 2 Simple Methods To Select All Non Blank Cells In An Excel Worksheet Data Recovery Blog Excel Data Recovery Recovery Blog Click OK to highlight the range of cells. . In the Ribbon select Home Find Select Go To. How do you reference non-adjacent cells in Excel. Click the first cell that you wish to select. Continue holding down the Ctrl key as you select the rest of your non adjacent cells. To do this go to the Home tab and click on the Find Select button. Click the Protect Sheet button then a dialog will pop up4. Another way to select non-adjacent cells is to use the Excels find and select tool. I thought it was simply to hold the ...