internet.com
You are in the: Small Business Computing Channelarrow View Sites +
Small Business Technology
» ECommerce-Guide | Small Business Computing | Webopedia | WinPlanet |  »Close
Webopedia.com
Enter a word for a definition... ...or choose a computer category.
 
 

menu
   Home
   Term of the Day
   New Terms
   Pronunciation
   New Links
   Quick Reference
   Did You Know?
   Categories
   Tech Support
   Webopedia Jobs
   About Us
   Link to Us
   Advertising
  

talk to us
   Submit a URL
   Suggest a Term
   Report an Error

internet.com
Developer
International
Internet Lists
Internet News
Internet Resources
IT
Linux/Open Source
Personal Technology
Small Business
Windows Technology
xSP Resources
Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers
commerce
  Be a Commerce Partner
 
 
 
 
 
 
 
 
 
 
 
 
 
 

relative cell reference
Last modified: Tuesday, November 12, 1996 

In spreadsheet applications, a reference to a cell or group of cells by indicating how far away it is from some other cell. For example, in Lotus 1-2-3 and many other spreadsheet programs, the cell reference "C2" is relative. Initially it points to the cell in the third column and second row, but it does this by specifying how far away this cell is from some other cell. For example, if you insert this reference in cell A1, the program will translate it to "2 columns right and 1 row down". If you then copy the reference to cell B4, it will now point to cell D5.

In contrast, an absolute cell reference always points to the same cell, no matter where the reference appears.

E-mail this definition to a colleague

Sponsored listings

SteelintheAir.com: Wireless Infrastructure News & Resources - Offers cellular tower consulting services, including lease negotiation and valuation assistance, competitive site analysis, and due diligence.

BioPerform: Stem Cell Venture Investment - Offers updates on life-science investment deals and opportunities, including exclusive stories on commercializing biotech discoveries and innovations.


For internet.com pages about relative cell reference . Also check out the following links!

Related Links

related categories

Spreadsheets

related terms

absolute cell reference

cell

spreadsheet


webopedia
Give Us Your
Feedback


Shopping
relative cell reference Products
Compare Products,Prices and Stores

Shop by Category:
Health Aids
0 Store Offers

Nutrition
0 Store Offers



JupiterWeb networks:

internet.comearthweb.comDevx.com graphics.com

Search JupiterWeb:

Jupitermedia Corporation has two divisions:
Jupiterimages andJupiterWeb


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Jupitermedia Corporate Info | Newsletters | Tech Jobs | Shopping | E-mail Offers