In a spreadsheet program, like Microsoft Excel, it is possible to select or highlight one or more cells, allowing you to apply formatting to those cells or copy the cells. To learn more about how to select cells, continue reading.

Select a single cell

To select a single cell in a worksheet, left-click the desired cell with your mouse. Once a single cell is selected, it becomes the active cell and appears bold or has a box surrounding the cell.

  • Select a single cell.
  • Select multiple individual cells.
  • Select a range of cells.
  • Select all cells.

If you need to select more than one cell, continue reading the next sections.

You can also use the keyboard arrow keys to move the selected cell (active cell). If nothing is contained in the cell, you can begin typing to insert text into the cell. If you want to modify pre-existing data in that cell, you can press F2 on the keyboard.

Select multiple individual cells

To select multiple individual cells in a worksheet, follow the steps below.

  • Press and hold Ctrl.
  • While holding Ctrl, left-click each cell you want to select.

As shown in the picture above, each selected cell is shaded to indicate it is selected.

Select a range of cells

Use one of the options below to select a range of adjacent cells in a worksheet.

If you want to change the properties of the selected cells once highlighted (e.g., changing the cell color), right-click any of the highlighted cells and select Properties.

When highlighting multiple cells, the active cell is also part of the highlighted cells. In our example above, cells B1, A2, C4, and B5 are all selected. Even though B1 is not shaded because it is active, it is considered a selected cell.

Option 1 - Drag mouse

  • Left-click with your mouse the first cell in the range you want to select.
  • While holding down the left mouse button, drag the mouse cursor to the last cell in the range.

For example, if you want to select cells A1 through A5, left-click the A1 cell, then drag the mouse to the A5 cell while still holding the left mouse button.

Option 2 - Shift click

  • Left-click with your mouse the first cell in the range you want to select.
  • Press and hold Shift.
  • While still holding Shift, left-click the last cell in the range.

For example, if you want to select cells A1 through E1, left-click the A1 cell, press and hold Shift, then click the E1 cell.

Using either of the options above, a range of cells should be selected, as shown in the pictures above.

Option 3 - Use the F8 key

  • Press F8.
  • Use the arrow keys to highlight all the cells you want highlighted. You can also use the mouse to click the ending position of what you want highlighted.
  • Once everything you want is highlighted, you can use another shortcut key such as Ctrl+C, to copy the highlighted cells or right-click the selection.

Select all cells

To select all cells in a worksheet, follow the steps below.

  • Move to the very top row and left-most column of the worksheet.
  • Click the square area with a shaded triangle, located above the “1” for the first row and to the left of the “A” column header. All cells in the worksheet are highlighted after clicking that square area.

You can also press Ctrl+A to select all cells in a worksheet.

  • How to select an entire row or column in a spreadsheet.
  • How to freeze or unfreeze rows or columns in a spreadsheet.
  • How to highlight or select text.
  • See our cell, highlight, and select definition for further information and related links.
  • Excel help and support.