Absolute Cell Reference

Definition - What does Absolute Cell Reference mean?

An absolute cell reference is a cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet.

Absolute cell references are important when referring to constant values in a spreadsheet.

Absolute cell reference may also be called absolute reference.

Techopedia explains Absolute Cell Reference

Absolute cell reference can be used when a particular cell reference needs to be constant. Cell references are often used in formulas, charts, functions and other commands. In some scenarios, it becomes important to keep a cell reference constant when it is copied to a different cell.

An absolute cell reference always remains the same no matter where it is copied and is often denoted by the "$" symbol. So, if B10 is a cell in a spreadsheet, $B$10 is used to denote that the reference always points to the 10th row in column B, even if that reference is copied to another cell or the spreadsheet is changed in some other way.

In many spreadsheet programs such as Excel, a cell reference can be made absolute by pressing the F4 key after the cell reference is typed. The spreadsheet will automatically make the cell reference absolute. If the F4 key is pressed continuously, the spreadsheet program will cycle through all of the absolute reference possibilities. For instance, if the cell reference is typed as $A1, continuous pressing of F4 will change the cell reference to A$1 and then A1. By pressing the F4 key cell references are changed directly to the left of the insertion point.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.