excel uses what technique to keep a cell reference constant when
excel uses what technique to keep a cell reference constant when copying a
fomular or function |
excel uses what technique to keep a cell reference constant when
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) "ajbanana" wrote in message ... excel uses what technique to keep a cell reference constant when copying a fomular or function |
excel uses what technique to keep a cell reference constant when
Microsoft Excel uses Absolute reference and not relative reference to keep
the cell reference constant. "ajbanana" wrote: excel uses what technique to keep a cell reference constant when copying a fomular or function |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com