Enterprise Storage Forum   Earthweb  
Events Research Images Premium Services Media Kit Network Map E-mail Offers Whitepapers Vendor Showcases
   subjects:
Search EarthWeb Network


IT Newsletters
CIO Digest
CodeGuru Update
C#/.net Tech Notes
Visual Basic Tech Notes
CrossNodes Networking
Windows Networking
Practically Networked
EnterpriseStorageForum (text)
EnterpriseStorageForum (HTML)
Optically Networked (text)
Optically Networked (HTML)
Datamation IT Management Update
Developer.com Update
XML Tech Notes
Gamelan Java Update
Goodies to Go
Web Design Goodies
Javascripts Update
JARS Java Update
OpenSource Update
OpenSource Project
SysOpt Tech Notes
Search for TERMS:
Enter a keyword...
 
...or choose a category
 

 absolute cell reference
LastModified: Wednesday, June 20, 2001 

In spreadsheet applications, a reference to a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. For example, in Lotus 1-2-3 and other spreadsheet programs, the cell reference "$A$3" is an absolute cell reference that always points to the cell in the first column and third row. In contrast, the reference "A3" is a relative cell reference that initially points to the cell in the first column and third row, but may change if you copy the reference to another cell or change the shape and size of the spreadsheet in some other way. Absolute cell references are particularly useful for referencing constant values (i.e., values that never change).

 
related categories:

Spreadsheets

related terms:

spreadsheet

absolute cell reference Products :


Top Store Offers:
A HerbalFinest & Co.  5.00All Natural Herbal Remedies that regularize bowel movements and are effective in the management of diarrhea or dysentery
SeSDERMA USA  58.50Food supplement indicated for periods of increased nutritional needs: tiredness, mental and physical fatigue, vitamin shortage, hypocaloric diets, pre...
WorldwideSurgical  789.98Compact and lightweight design for hospital pump – Weighs only 6 pounds Offers suction and speed controls, which can be adjusted independently of on...
Crutchfield  179.99for all docking iPods, including 120 GB iPod classic, 2nd generation iPod touch, and curved screen iPod nano,two 3-1/2" high-performance full-range sp...
SitStay.com  10.95Helps to restore healthy joint function by stimulating: cartilage regeneration, fast pain relief, reduction of inflammation, improved mobility, regene...

Compare all matches:
0 Store Offers







IT ManagementNetworking & CommunicationsWeb DevelopmentHardware & SystemsSoftware Development
Earthweb Homeglobe
IT Jobs Events Training & Certification

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers