Cells and cell names

1 / 5

A spreadsheet is a grid of boxes. Each box is called a cell.

keyboard Typing formulas is easiest on a computer with a keyboard.

A1
ABCDEF
1ItemQtyPriceYour answer
2Monitor Stand240.49
3Headset4120.99
4Office Chair295.5
5Bookshelf6155.99
6USB-C Hub242.5
7
8
9
10
11
12
a cell
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
Study notes

In a bit more detail

  • What is a cell?

    A spreadsheet is a grid of boxes called cells.

  • What are columns and rows?

    • Columns run down the sheet and are named with letters: A, B, C...
    • Rows run across and are numbered: 1, 2, 3...
  • How is a cell named?

    By its column letter, then its row number. The cell in column B, row 3 is B3. The name of the selected cell is shown in the box at the top left of the grid.

Know someone fighting with a spreadsheet? Send them this page.