[libreoffice-users] Re: How do I move a formula without changing it?

On 1/4/15 10:43 AM, Gordon Burgess-Parker wrote:
> Yes - add $ to the cell references in the formula - e.g., A2 becomes
> $A$2. That means you can move the formula anywhere you want but it will
> still reference A2...

I know that but that is what I am trying to avoid.  I would have to 
change it to copy and then change it back after I move it so I can drag 
the next year.

I am looking for a way to copy and paste the existing formulae without 
changing them.  This may not be possible but I thought I would check. 
If I can't do that I will have to investigate to see what the fewest 
number of cells I actually must change are and take it from there.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted