I have Excel 2007, when I paste special formulas from one cell (let's say A1) to all other cells in A column,
it copies formulas OK, but it shows value of what formula calculated for A1. Then, I need to go to every single cell and press "Enter" to get the correct value.
it copies formulas OK, but it shows value of what formula calculated for A1. Then, I need to go to every single cell and press "Enter" to get the correct value.