Absolute Cell Reference

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).

Vangie Beal
Vangie Beal
Vangie Beal is a freelance business and technology writer covering Internet technologies and online business since the late '90s.

Top Articles

Huge List Of Texting and Online Chat Abbreviations

From A3 to ZZZ we list 1,559 text message and online chat abbreviations to help you translate and understand today's texting lingo. Includes Top...

How To Create A Desktop Shortcut To A Website

This Webopedia guide will show you how to create a desktop shortcut to a website using Firefox, Chrome or Internet Explorer (IE). Creating a desktop...

The History Of Windows Operating Systems

Microsoft Windows is a family of operating systems. We look at the history of Microsoft's Windows operating systems (Windows OS) from 1985 to present...

Hotmail [Outlook] Email Accounts

  By Vangie Beal Hotmail is one of the first public webmail services that can be accessed from any web browser. Prior to Hotmail and its...

Common Business-Oriented Language (COBOL)...

What is COBOL? COBOL stands for Common Business-Oriented Language. It is a 60-year-old programming...

Shared Hosting Definition &...

Shared hosting is a web hosting model in which multiple sites occupy the...

Database Integration Definition &...

Database integration consolidates data from multiple sources to provide businesses with more comprehensive...