Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Sumproduct issues | Excel Worksheet Functions | |||
Excel - print to .pdf using filename reference from cell | Excel Discussion (Misc queries) | |||
Enter an Excel cell reference as part of a custom header/footer | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |