excel uses what technique to keep a cell reference constant when

[Guest]

excel uses what technique to keep a cell reference constant when copying a
fomular or function

 

[Chip Pearson]

I'm not sure what you're asking, but I think that Absolute References are
what you are looking for, e.g., $A$1 instead of A1. See
http://www.cpearson.com/excel/relative.htm for more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

Microsoft Excel uses Absolute reference and not relative reference to keep
the cell reference constant.