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.

Posted by:
Recommended For You close
BSD: The Other Free Unix

Read More »

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
Techopedia on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!
Techwise Webinar Series
The Cloud Imperative - What, Why, When, And How
The Cloud Imperative - What, Why, When, And How:
Join veteran analysts Dr. Robin Bloor of The Bloor Group, and Mark Madsen of Third Nature, as they explain how today’s cutting edge Cloud solutions can deliver enterprise caliber software like never before.

Email Newsletter

Join 138,000+ IT pros on our weekly newsletter

Resources
Free Whitepaper – Bridging the IT Operations Application Owner Gap
Free Whitepaper – Bridging the IT Operations Application Owner Gap:
Conflicting organizational needs all too often create tension between functional silos. Application owners demand more and more resources.
Free 30 Day Trial – VMTurbo Operations Manager
Free 30 Day Trial – VMTurbo Operations Manager:
VMTurbo's flagship product, Operations Manager maintains your virtual and cloud environments in a healthy state. It manages homogeneous and...