R
Riley Franklin
In one of my workbooks I have two worksheets with this
problem which occurs using either copy & paste or fill: I
have a formula in one cell that I want to copy to an
adjacent cell and calculate the new result for that cell.
Excel copies the formula correctly but instead of
calculating the new value for the 2'nd cell it merely
copies the value frome the 1'st cell. Is there a setting I
can change to copy the formula and calculate the new value?
problem which occurs using either copy & paste or fill: I
have a formula in one cell that I want to copy to an
adjacent cell and calculate the new result for that cell.
Excel copies the formula correctly but instead of
calculating the new value for the 2'nd cell it merely
copies the value frome the 1'st cell. Is there a setting I
can change to copy the formula and calculate the new value?