Press the mouse left button while your cursor is on row number 2.
WHY IS EXCEL AUTOMATICALLY SELECTING MULTIPLE CELLS HOW TO
Here is how to select non-adjacent multiple rows in Excel: To do this, you will have to use a combination of keyboard and mouse. In such a case you cannot use the mouse drag technique covered above because it would select all the rows in between. What if you want to select multiple rows, but these are not-adjacent.įor example, you may want to select row numbers 2, 4, 7. Select Multiple Non-Adjacent Rows/Columns Just like we have selected three adjacent rows, you can follow the same steps to select multiple columns as well. You’ll see that this would select three adjacent rows that you covered through your mouse. Keep the mouse left-button still pressed and drag the cursor down till row 4.Press the mouse left button while your cursor is on row number two (keep the mouse button pressed).Place the cursor over row number 2 in the worksheet.What if you want to select multiple rows?įor example, let’s say that you want to select row number 2, 3, and 4 at the same time. Now, what if you don’t want to select just one row. Just like we have selected a row in Excel, you can also select a column (where instead of clicking on the row number, you have to click on the column alphabet, which is at the top of the column). When you select the entire row, you will see that the color of that selection changes (it becomes a bit darker as compared to the rest of the cell in the worksheet). Use the left mouse-click to select the entire row.Bring the cursor over the row number of the row that you want to select.Here is how you can select an entire row in Excel: Just like you can select a cell in Excel by placing the cursor and clicking the mouse, you can also select a row or a column by simply clicking on the row number or column alphabet. These could be to hide or delete these rows/columns, move it around in the worksheet, highlight it, etc. Select Rows/ColumnsĪ lot of times, you will be required to select an entire row or column (or even multiple rows or columns). Drag the cursor till cell D10 (so that it covers all the cells between A1 and D10).Select cell A1 (by using the left mouse button).If you know how to select one cell in Excel, I’m sure you also know how to select multiple cells. Select Multiple Cells (that are all contiguous) Select All the Cells in the Current Table/Data.