title: Lock Relative Referencing in Excel with R1C1
body: <p>Is there a way of locking down the relative reference in a R1C1 style forumla. For example adding a row the just before the reference changes the formula from RC[-1] to RC[-2] however I want it to remain static i.e. RC[-1].</p>