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
 
 
 
 
 
 
 
 
 
 
 
 
 
 

absolute cell reference
Last modified: 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).

E-mail this definition to a colleague

Sponsored listings

Find Absolute Encoders Now at Newark InOne - Huge selection of absolute encoders. Most items Most items in stock and ready to ship same day. Leader in RoHS compliance.

Digi-Key: Absolute Encoders - Broad-line distributor web site features real-time stock status and pricing, online ordering, RFQ, technical support, product datasheets and photos.

Siemens Industrial Automation: Absolute Encoders - PROFINET offers decentralized IO, peer-to-peer communications, data visibility, machine safety, and motion control on one Industrial Ethernet network.


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

Related Links

Sponsored listings

Advanced Micro Controls: Absolute Encoder - Manufactures the DuraCoder size 25 rotary shaft encoder. An industrial-grade rotary sensor designed for a variety of applications.

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

Encoder Products Co.: Absolute Encoders - Offers rugged absolute electrical relay encoders for process and machine control, motor feedback, factory automation, robotics and web tensioning.

Endress+Hauser: absolute pressure measurement - Supplies industrial automation and control, test and measurement, and information system solutions.

GlobalSpec: Absolute Relays Encoders - Engineering search engine for technical information on absolute relays encoders companies. Browse catalogs and contact suppliers.

related categories

Spreadsheets

related terms

spreadsheet


webopedia
Give Us Your
Feedback


Software
absolute reference Products


Shop by Top Models:
Absolute Software LoJack® for Laptops Full Version for PC
2 store offers from $50 - $50

Absolute Software Computrace LoJack for Laptops for PC
1 store offers from $50 - $50

Advantrics Absolute Office Microsoft® FrontPage® Templates
3 store offers from $70 - $70

Absolute Software Computrace LoJack Laptop Recovery Service Full Version for PC
2 store offers from $80 - $80

Absolute Software Computrace LoJack for Laptops Full Version for PC
2 store offers from $120 - $120



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