Michelle Konzack wrote:
Hello Brian,
Yes and Excel 2.0+ has saved me headaches because it.
When using Calc, I had tonns of errors because it has changed the ROW
NUMBERS in calculatins and when I found out that it adapt it t the new
ROW, I had to change all back by hand.
Is there an option to stop this?
In my case, it is a VERY annoying feature-bug.
If you need to "lock" in a cell use the $. Example A2 would be A$2,
when you copy/paste that the row would be 2, no matter where you paste
it. The column can be locked the same way, $A$2 would lock both.
Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]