View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default locking formula cell references

You must reference B$2

HTH
--
AP

"Superchikn" a écrit dans le message
de ...


I have a cell that references B2 i need the reference to stay at B2 even

if
i insert a row at row 2. Currently the reference moves to B3. Is there any
way around this?