I have a simple formula in E6 (B6*C6). My problem is when I insert a new row into B6:C6, my formula in E6 changes from (B6*C6) to (B7*C7). I want the formula in E6 to ALWAYS be (B6*C6) no matter how many times I insert a new row into B6:C6. I've tried to use $B6*$C6 but it seems to change when I insert a new row. Your help is greatly appreciated.