When cells, rows, or columns are deleted, Excel updates formulas by adjusting cell reference to the shifted cells, reflecting their new locations. You will see the error value  #REF! for a formula that refers to a deleted cell.  To fix it, adjust the references manually after the deletion.