I've data in 3 columns.
2 Yearly percent change.
3 Daily percent change.
I've used formula for yearly change,
and for the daily change this one has been used.
But Excel does not automatically fills both cells when I add new value in first column.
I do not want to copy down the formula in each columns because I do not want to see
What should I do?