Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anchor Reference in a Formula
I have a formula which I donīt know how to copy it to the right,
leaving one of his arguments fixed. See the attachement with an example Excel 2007 version ! http://www.exceluciones.com/SumIfExample.zip (if you can not clic on link copy and paste it to your browser to download zip file) I will appreciate any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Anchor Reference in a Formula
hi,
you want an absolute reference in your formula. to do that just put a dollar sign ($) in front of the reference that you want "fixed". example A1 - relative reference. column and row reference varies depending on where you paste $A$1 - absolute reverence. column and row reference remains constant no matter where you paste. $A1 - Absolute column reference, relative row reference, meaning the column remains "fixed", row varies depending on where you paste. A$1 - relative column reference, absolute row reference, meaning the column varies depending on where you paste, row remains "fixed". read up on absolute/relative references in xl help. Regards FSt1 "RCL" wrote: I have a formula which I donÂīt know how to copy it to the right, leaving one of his arguments fixed. See the attachement with an example Excel 2007 version ! http://www.exceluciones.com/SumIfExample.zip (if you can not clic on link copy and paste it to your browser to download zip file) I will appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Do You ANCHOR a Cell Reference? | Excel Discussion (Misc queries) | |||
HTML Anchor tag? (name tag)... | Excel Discussion (Misc queries) | |||
Anchor Doesn't work | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
How do I anchor adjacent cells ? | New Users to Excel |