Cell

Updated: 05/02/2021 by Computer Hope

A cell may refer to any of the following:

1. A cell is the intersection where a row and a column meet on a spreadsheet that starts with cell A1. In the following example, a highlighted cell is shown in a Microsoft Excel spreadsheet. D8 (column D, row 8) is the highlighted cell that's also known as the cell address and cell reference. Any modifications made while this cell is highlighted will be limited to this cell in the worksheet.

Spreadsheet

Here, D8 is the active cell. In the formula bar, you can see that the cell content is =SUM(D2:D5). This formula evaluates the result of $162.00 by calculating the sum of the values stored in cells D2 through D5.

Each cell in a spreadsheet can contain any value that can be called using a relative cell reference or called upon using a formula.

How can you determine the cell reference?

While moving in a spreadsheet with the keyboard arrow keys or by clicking a cell with the mouse, the cell reference (cell address) is updated. Also, the column and row headers are highlighted. In the above picture, you can see the "D" column, and the "8" row is highlighted in yellow.

How do the rows and columns increase?

When you first open the spreadsheet, the active cell is always placed in the first column (column "A"). As you move to the right, the columns are increased by going through the English alphabet. So, pressing the right arrow key once moves the active cell into the "B" column, pressing the right arrow again moves the active cell into the "C" column, etc. When you get to the last letter of the alphabet ("Z"), the columns become two letters with the "AA" column, then "AB," "AC," etc. After getting to "AZ," the columns become "BA," "BB," "BC," etc. If you were to get to "ZZ," the next column would increase to three letters and start with "AAA," then "AAB," "AAC," etc.

Rows are increased numerically, starting with the first row of number "1." Pressing the down arrow key would increase the row to "2," and pressing it again would increase the row to "3."

Tip

See our spreadsheet definition for further information on using spreadsheets.

How to move between cells

To move between cells in a spreadsheet, click the cell where you want to move to or use the arrow keys to move up, down, left, and right one cell. You can also use the page up and page down keys to move one page at a time.

2. Like a spreadsheet cell, a cell is a section within an HTML table that is created using the HTML <td> tag.

3. Cell is another name for a cell phone.

4. A cell refers to a unit of data that is transferred over an ATM network.

5. Cell is the geographical area that a cell tower covers for cell phone reception. It is often measured in square miles and may overlap with another cell tower's cell.

Cel, Range, Relative cell reference, Row, Spreadsheet, Spreadsheet terms