In fact, it works exactly like selecting rows.Ĭlick a column letter to select the column. Sometimes, you may want to select an entire column of cells. Select One or More Entire Columns of Cells In the image below, we’ve deselected two rows from a selected range by holding down the Ctrl key while clicking the row numbers of the rows we didn’t want in the selection. In the image below, we’ve selected several rows that are noncontiguous.Īnd, just like with individual cells, you can also use the Ctrl key to deselect rows from a selected range. Then hold down your Ctrl key while clicking the row numbers of additional rows you want to add to the selection. To select noncontiguous rows, click the row number of a row you want to select. Either way, you’ll select a range of rows. First of all, use your keyboard left-right arrow to go the cell of the row which you want to delete.After that follow the steps given below. This is a 2 step method and the fastest method to select and remove the row. The method is useful when you want to delete only the single row in excel. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select. Delete Single Row in Excel Using Keyboard. To select a contiguous set of rows, click the row number of the first row.Ĭontinuing to hold down your mouse button, drag your cursor across all the rows you want to select. If you know the exact range of cells you want to select, using the name box is a useful way to make the selection without any clicking or dragging. Select a Range of Cells Using the Name Box In the image below, we deselected several cells from a range of cells we’d already selected just by holding down the Ctrl key while clicking the cells. You can also use your Ctrl key to deselect an already selected cell-even from a selection range. In the image below, we’ve selected five different cells. Now, hold down the Ctrl key and click to select additional cells. You can also select multiple cells that are not connected to one another by using your Ctrl key. Select (or Deselect) Independent Cells Outside a Range With the Ctrl Key Hold down your Shift key, and then click that cell.Īll the cells in the range are now selected. Scroll your sheet until you find the last cell in the range you want to select. Click the first cell in the range you want to select.