Nov 26 2019 09:18 AM
Nov 26 2019 09:18 AM
New user here
So I am studying excel and I noticed that on my version (the latest I believe, registered and downloaded a few days ago), when I enter a formula, the cell above is immediately whitened out.
I can solve this for a specific cell if I go to cell formatting and choose 'distributed' for vertical (even though I am not quite sure what the other options are etc at this point) , but the issue still remains by default.
Is there any way to resolve this permamently ?
Jun 26 2020 08:26 AM
@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.
Jun 26 2020 08:35 AM
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
Jun 26 2020 08:41 AM - edited Jun 26 2020 08:43 AM
@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.
Jun 26 2020 05:02 PM
Ah yes, that is annoying. Normally I end up just editing / writing the formula in the formula bar instead when that happens
Sep 03 2021 12:58 AM
I've worked around this issue for a while now and just decided to try and find out why it does this and the comment from mtarler brought me to the conclusion.
The issue seems to be an excel issue when the row height is default for the size of the font you are using.
This seems to happen with any font size but when the row height is auto sized it is ONE pixel too small.
Manually increasing the row by that one pixel now makes the cell editable without blocking out the above cell.
With a little luck someone will figure this out and make the change to the excel code as it is rather annoying.