View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peaceful Wisdom
 
Posts: n/a
Default stop insert from changing cell reference

I have a cell that references the row above it and three columns to the left.
If I insert a row, the reference changes to two rows above. How can I stop
this, and have it stay at one row above? Thanks.