On 04/01/15 15:39, Robert Peirce wrote: > 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? > >
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... -- To unsubscribe e-mail to: [email protected] 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
