Forum Discussion
Deleted
Jul 18, 2018Control R and Control D not working correctly
This just started with Excel a couple of day ago. When I place a formula in a cell at the right end cell or at the bottom cell of a column works just fine. However when I highlight the bottom cells...
Deleted
Jul 18, 2018Yes they do copy correctly but even though the formula are correct it is like the spreadsheet is not reading the formula
SergeiBaklan
Jul 18, 2018Diamond Contributor
Jeff, if you mean it's not calculates by formula please check if in File->Options->Formulas you have selected Automatic mode of calculation
- DeletedJul 18, 2018Manual is selected
- SergeiBaklanJul 18, 2018Diamond Contributor
Just change on Automatic. Another way in ribbon Formulas tab, Calculations Option->select Automatic.
- DeletedJul 18, 2018That did it! Thanks Sergei!