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

I have some rate-of-change triangles I need to change.  These show the 
annual rate of change for different numbers of years and look like this:

2010    X       X       X       X       X
2011    X       X       X       X
2012    X       X       X
2013    X       X
2014    X

Basically, I want to reverse the lines, moving the top to bottom and 
vice versa.  I want to do this so the multiple years go out from the 
ending date instead of the starting date.  Like this:

2010    X
2011    X       X
2012    X       X       X
2013    X       X       X       X
2014    X       X       X       X       X

If I just copy and paste and the cells aren't protected by '$' the cells 
change accordingly.  I don't want that to happen.  I want the formulae 
to reference the same cells.  I just want to move them to another 
location.  Is there any way to do this?


--
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