Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,807,486,279 visitors served.
forum mailing list For webmasters
?
New: Language forums
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

cell reference

    0.10 sec.
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.
(spreadsheet)cell reference - 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".


How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
 Email
Feedback
? Mentioned in ? References in periodicals archive
 
Notice the absolute cell reference ($) should be used before copying this formula to other cells.
Double-teaming in Excel: spreadsheets now can solve tougher ... by Brickner, Daniel R. / Journal of Accountancy
processor appearing in products such as Sony Computer Entertainment's PLAYSTATION[R]3 computer entertainment system, and Toshiba's Cell Reference Set, a development tool for Cell/B.
College of Computing at Georgia Tech Hosts Workshop to Drive ... by Business Wire
If you want the worksheet to open at a particular place, enter the cell location (such as R45) in the space next to Type the cell reference with the cell where you want the Revenue worksheet to open.
Technology Q&A: command word to repair itself ... create an Excel ... by Zarowin, Stanley / Journal of Accountancy
More results
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2009 Farlex, Inc.
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information 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. Terms of Use.