Understanding cells

Thousands of rectangles, which are called cells, are composed of each worksheet. In other words, when a row and a column meet, a cell is the intersection of a row and a column.

Columns are identified by letters (A, B, C), while numbers (1, 2, 3) are used to classify rows.Based on its column and row, each cell has its own name—or cell address. Column C and row 5 are intersected by the selected cell, so the cell address is C5.

Note that the cell address is also displayed in the top-left corner of the Name box, and that the column and row headings of a cell are shown when the cell is picked.

You can also simultaneously choose several cells. As a cell set, a group of cells is identified. You refer to a cell range instead of a single cell address, using the cell addresses of the first and last cells in the cell range. Separated by a colon. A cell set including cells A1, A2, A3, A4, and A5 will for example, be written as A1:A5. Look below at the various cell ranges:

  • Cell range A1:A8
  • Cell range A1:F1
  • Cell range A1:F8

You will need to change the default reference style for Excel if the columns in your spreadsheet are labelled with numbers instead of letters.

Selecting a cell:

You will first need to select the cell in order to input or edit cell material.

  1. To pick a cell, click it. We will select cell D9 in our case.
  2. A border will appear around the selected cell, highlighting the header of the column and the header of the row. Until you click another cell on worksheet, the cell will remain picked.

You can also select cells by using your keyboard’s arrow keys.

Selecting a cell range:

Often, you may want to pick a larger group or several cells.

  1. Click and drag the mouse until it highlights all the adjoining cells you want to pick. We will select the range of cells B5:C18 in our example.
  2. To choose the appropriate cell set, release the mouse. Until you click another cell in the worksheet, the cells will remain picked.