Home  >  Article  >  Topics  >  What is the way to identify a cell?

What is the way to identify a cell?

烟雨青岚
烟雨青岚Original
2020-07-10 13:30:048768browse

The way to identify a cell is "column label row number", for example: A1, C3. A cell is the intersection of rows and columns in a table. It is the smallest unit that makes up a table and can be split or merged; individual data is entered and modified in cells.

What is the way to identify a cell?

The way to identify a cell is the column label and row number, which can also be called row label. For example, A1, C3.

The cell is the intersection of rows and columns in the table. It is the smallest unit that makes up the table and can be split or merged. The input and modification of individual data are performed in cells.

Cells are named according to their row and column positions. They have three reference styles: A1 reference style, R1C1 reference style and three-dimensional reference style.

A1 reference style

By default, Excel uses the A1 reference style, which references letter-identified columns (from A to IV, a total of 256 columns, Note: The maximum number of columns varies between versions), and the reference number identifies the row (from 1 to 65,536). These letters and numbers are called row and column numbers. To refer to a cell, enter the column label and row number. For example, B2 refers to the cell at the intersection of column B and row 2.

R1C1 Reference Style

You can also use the reference style that simultaneously counts rows and columns on the worksheet. The R1C1 reference style is useful for counting rows and columns located within macros. In the R1C1 style, Excel indicates the location of the cell with the row number after R and the column number after C. For example, R2C3 is equivalent to C2 in the A1 reference style, which refers to the cell at the intersection of row 2 and column 3 (that is, C).

Three-dimensional reference style

If you want to analyze data in the same cells or cell ranges on multiple worksheets in the same workbook, you need to use three-dimensional Quote. A 3D reference consists of a cell or range reference preceded by the range of the worksheet name.

Excel uses any worksheet stored between the referenced start name and end name.

For example, =SUM(Sheet2:Sheet13!B5) will calculate the sum of all values ​​contained in cell B5, and the cell value range is from Sheet 2 to Sheet 13.

Recommended tutorial: "excel tutorial"

The above is the detailed content of What is the way to identify a cell?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn