How To Select Cells in MS Excel

Select Cells in MS Excel

Selecting cells in Excel | PTR

In Excel, you can select a single cell, a set of adjacent cells as well as non-adjacent cells. You can also select an entire row, an entire column, and an entire worksheet. In Excel, you can select cells using the mouse or keyboard or a combination of both.

To select a single cell:

  • Click on the cell with the mouse. The borders of the cell appear bold. You can also move with the help of arrow keys to reach the cell which you have to format.

To select a group of adjacent cells

  • Select the first cell in the group. Now, press and hold down the Shift key and with the help of the arrow keys, select the group of adjacent cells you want. All the selected cells will be highlighted in blue color. Adjacent cells can be selected with the help of the mouse also. Click on the first cell and without releasing the mouse button, drag the mouse to select the group of adjacent cells you want.

To select a group of non-adjacent cells:

  • Select the first cell. Now, press and hold down the Ctrl key and keep on clicking in the cells that are to be selected. Release the Ctrl key when there are no more cells to be selected.

To select an entire row:

  • Move to the first cell in a row. Press Ctrl + Shift + → (right arrow key) to select the entire row. You can also click on the row heading (the horizontal row numbers 1, 2,…) to select the entire row.

To select an entire column:

  • Move to the top most cell in the column. Press the Ctrl+ (down arrow key) to select the entire column. You can also click on the column heading (the vertical column names A, B,…) to select the entire column.

To select an entire worksheet:

Select Cells in MS Excel
Select Cells in MS Excel
  • Press Ctrl + A or Ctrl + Shift + Space Bar to select an entire worksheet. You can also click on as shown in Figure 5.1 on 4 the top left corner of the Excel worksheet to select the entire worksheet.