Forum Discussion
When I enter a formula the cell above is automatically 'blocked' from view
Wyn Hopkins Here is a partial screenshot of what the original poster is talking about. I can't click on the field above the field where I have started the formula.
Ah yes, that is annoying. Normally I end up just editing / writing the formula in the formula bar instead when that happens
WuLaw Bunin i only get this behavior when the row height isn't tall enough for the text so Excel 'creates more room' by temporarily hiding the cell(s) above it. Does it still happen if you select all and do autoheight or double-click a horizontal line between row numbers?
EDIT: a) i see Sergei replied with very similar comment
b) you can also change to a smaller font size that will fit that row height.
After = you may use arrow keys to select navigate to the cell. If you prefer the mouse then increase the row height. Or on ribbon Home->Format->Autofit row height
