Forum Discussion
Anonymous
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...
Anonymous
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
- AnonymousJul 18, 2018Manual is selected
- SergeiBaklanJul 18, 2018Diamond Contributor
Just change on Automatic. Another way in ribbon Formulas tab, Calculations Option->select Automatic.
- AnonymousJul 18, 2018That did it! Thanks Sergei!