How do I keep a cell reference the same even if a row is inserted?

  • Thread starter Thread starter apr
  • Start date Start date
A

apr

EG. My cell reference in Sheet1 is ='sheet2'!$A$2 but if a row is inserted on
Sheet2 above relevant row the formula changes to ='sheet2'!$A$3.
I want it to remain the original reference regardless of any changes on
Sheet2.
 
Back
Top