Place a $ in front of a row and/or column that you don't want changed when formula is copied.
For example $RES.J5 should be $RES.$J$5 I don't understand what $'4' means? -- Dennis Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back up any files involved and use at your own risk. Batteries not included. Not for internal use. Don't run with knives. "Comisión Histórica" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I am using open office calc, and I need to know how should I copy a formula keeping constant any value. Because when I am copying a formula values like "$RES.H5*$´4´.H5+... CHANGES TO "$RES.J5*$´4´.J5+... AND I WNAT TO KEEP CONSTANT H5 AND CHANGE ´4´ TO ´5´ AND I CAN´T DO IT. I will thank you a lot if you could give me the solution. William --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
