Cell reference



spreadsheet
A string identifying a particular cell in a spreadsheet, possibly relative to the cell containing the reference. A cell reference may be absolute (denoted by a “$” prefix in Excel) or relative (no prefix) in each dimension, thus, e.g. B$6 refers to the second cell across in the sixth row. The distinction between absolute and relative is only significant when the referring cell is copied, e.g. if cell A1, which refers to B$6, is copied to cell B1, then B1 will refer to C6.
If the reference is to a cell in a different sheet then it is prefixed with the target sheet’s name and an exclamation mark. E.g. “Sheet 1!B3”.
(2007-10-22)

Tagged:

Read Also:

  • Cell-sap

    the watery fluid within the central vacuole of a plant cell. Historical Examples cell sap The liquid contained within a vacuole of a plant cell. See more at vacuole.

  • Cell space simulation language

    language (CESSL) A language for simulating cellular space models. [“The CESSL Programming Language”, D.R. Frantz, 012520-6-T, CS Dept, U Michigan, Sept 1971]. (1994-12-14)



  • Cell-theory

    a basic tenet of modern biology, first stated by Matthias Schleiden and Theodor Schwann in 1838–39, that cells are the basic units of structure and function in living organisms. Historical Examples

  • Cell-wall

    the definite boundary or wall that is part of the outer structure of certain cells, as a plant cell. Historical Examples noun the outer layer of a cell, esp the structure in plant cells that consists of cellulose, lignin, etc, and gives mechanical support to the cell cell wall n. The rigid outermost cell layer […]



Disclaimer: Cell reference definition / meaning should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. All content on this website is for informational purposes only.