cell reference

[′sel ‚ref·rəns]

(computer science)

The address of a cell that contains a value that is needed to solve a formula in a spreadsheet program.

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".

Mentioned in ?

References in periodicals archive ?

Using the mouse or arrow keys will insert =GETPIVOT DATAO functions instead of the cell reference.

Excel: CREATING TABLES FROM TIMELINE SLICERS

By naming the assumption cell, you can also reference the cell name when creating formulas instead of typing the cell reference.

Rules for designing Excel workbooks

Tenders are invited for support specialized collaboratory that will adopt scalable technology platforms and streamlined workflows to generate a comprehensive 3d brain cell reference atlas encompassing molecular, anatomical, and physiological annotations of brain cell types in mouse, and incorporate additional genetic and other advanced cell-specific targeting approaches and tools to facilitate this goal.

Brain Initiative Cell Census Network (biccn) - Specialized Center On Mouse Brain Cell Atlas (u01)

8226; Cell reference hyperlinks do not work in resultant HTML

Set Link Target Type for HTML Conversion, Access & Update Portion of Rich Text in Cell Using Aspose.Cells for Java 8.6.1

Features such as viewing all cells together and cell classes side-by-side; access to a cell reference library; the patient's historical images; and the ability for multiple users to collaborate in real-time from any location worktogether to reduce the inherent subjectivity of morphological analysis.

The manual differential enters the digital age

This is done by adding another cell reference to the output cell B7 as shown in cell F3 of Figure 6.

Balancing the state college budget: why must tuition increase and by how much?(Instructor's Note)

Over the past 2 years Tata Elxsi emerged as the market leading provider of LTE small cell reference design and protocol software for L2/L3 and L1 optimized to market leading processors.

Tata Elxsi shortlisted for prestigious Femto Forum awards 2011 in UK

Similarly, the CD4+ T cell reference range in healthy adults from Turkey was from 437 to 2072 (mean 1095 and median 1055 cells/[micro]l) (57).

A review on peripheral blood CD4+ T lymphocyte counts in healthy adult Indians

Enter relative references for flow and absolute roughness and absolute references (using the F4 key after the cell reference is entered) for the global inputs for design static, kinematic viscosity and specific volume.

Using excel for duct calculations: user defined functions

Just to the left of the formula bar where the formula =SUM(B104:B133) appears is the cell reference B134.

The case of simulating the choices of money mangers by applying modern portfolio theory using real stock price data

Lymphocyte, monocyte, and natural killer cell reference ranges in postpartal women.