Show Summary Details

Page of

PRINTED FROM OXFORD REFERENCE ( (c) Copyright Oxford University Press, 2013. All Rights Reserved. Under the terms of the licence agreement, an individual user may print out a PDF of a single entry from a reference work in OR for personal use (for details see Privacy Policy and Legal Notice).

date: 01 April 2020

absolute address 

The Concise Oxford Dictionary of Mathematics

Christopher Clapham,

James Nicholson

In spreadsheets a formula which is to appear in a number of cells may wish to use the contents of another cell or cells. Since the relative position of those cells will be different each time the formula appears in a new location, the spreadsheet syntax allows an absolute address to be specified, identifying the actual row and column for each cell. When a formula is copied and pasted to another cell, a cell reference using an absolute address will remain unchanged. A formula can contain a mixture of absolute and ... ...

Access to the complete content on Oxford Reference requires a subscription or purchase. Public users are able to search the site and view the abstracts and keywords for each book and chapter without a subscription.

Please subscribe or login to access full text content.

If you have purchased a print title that contains an access token, please see the token for information about how to register your code.

For questions on access or troubleshooting, please check our FAQs, and if you can''t find the answer there, please contact us.