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 ?

Learn some basic functions and formulas and how to use absolute cell reference. Other things discussed include Tables and PowerPivot Tables.

Books and enrichment Submit your events at dailyherald.com/share

Starting at the upper left-hand cell of the covariance matrix, enter the cell reference for the standard deviation for that investment (from the column data) times the cell reference for the standard deviation for that investment (from the row data) times the cell reference for the correlation of that asset with itself.

BUILDING OPTIMAL RISKY AND UTILITY MAXIMIZING TIAA/CREF PORTFOLIOS

By naming the assumption cell, you can also reference the cell name when creating formulas instead of typing the cell reference. This can make the formula easier to write and review.

Rules for designing Excel workbooks

• 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

In the cell reference input $B$134, select =, and in the Constraint input 1.

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.