Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
5,180,072,105 visitors served.
forum Join the Word of the Day Mailing List For webmasters
?
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

cell reference

    0.01 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".
Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link 		Feedback
Mentioned in?  References in periodicals archive?   Encyclopedia browser?   Full browser?
 
So What Are Function Arguments There are essentially four types of data arguments that could be used in a function and they are Text Arguments, Numeric Arguments; Logical Value Arguments and Cell Reference Arguments.
Microsoft Excel 2003 Basics - What Is Function Syntax? by vijay / Advertising, marketing, public relations community
Once you have typed in the Cell address like C4 you can move back into the cell address and then use the F4 key to toggle the cell reference from Relative to Absolute to a Mixed References.
Absolute References Vs Relative References in Microsoft Excel.. by heena jain / Computers and office automation community
Use cell references for any other cell that requires the value.
An activity-based costing assessment task: using an excel spreadsheet by Ringelstein, Damian / e-Journal of Business Education and Scholarship Teaching
 
 
 
Encyclopedia
?

Mobile Site | Terms of Use | Privacy policy | Feedback | Advertise with Us | Copyright © 2013 Farlex, Inc.
Disclaimer
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.