I have been facing a rather strange problem in Excel - it's not easy to explain so I have also attached a screenshot to help
When I type a formula into a cell and press 'Enter', the formula executes but the answer does not appear immediately in the cell. Instead, I have to click on some other cell, or perform some other operation for that number to show up. This does not happen when the cells included in the formula are on the screen. For example, if I were to input "=A1+A2" into A3 and press 'Enter', the answer would appear. However, if I were to input "=A1+A2" into A27 (where A1 and A2 are not visible on screen) and press 'Enter', the cell will remain blank until I double click it or perform some other operation!
This has really been driving me crazy! Does anyone have any possible explanation or solution to this? For what it's worth, I'm on Excel 2016 for Mac.
A27
has a strange formatting. Now I remember: once this was due to formatting of cell. Try to force it as number (Control-1). Sometime excel go crazy with a forced text format. If it works, you can copy empty cells (just below everithing) to the affected range of cells.