Cell editing covers adjacent cell/s

Copper Contributor

Zoldyckillua_0-1642642992982.png

As shown above, editing directly on the cell unnecessarily covers other cells even when included in the formula and also happens even when I press the F2 hotkey. I have been used to doing this before with an earlier version of Excel and this never occurred to me, only now with Office 2016. Is there any way to resolve this? Or do I have to start getting used to clicking on the formula bar instead, because it seems to show all cells referenced by the formula I am editing.

 

Zoldyckillua_0-1642644385795.png

Edit: Well, now sometimes it would show the whole cells without covering it up. I don't get it. Is this suppose to be a bug or something?

2 Replies
Have not thought much about how to get around it. I just use the formula bar.
But, F2 is a really good to know key. When you have 'opened' the cell for editing (first press of F2), it switches to change the mode for the arrow keys between Edit (for moving the cursor inside the formula) or for selecting cells (pointing or Enter). Even more valuable eg when defining names and you definition is a formula that you want to edit.
Well, it is help you better edit your formula.

You'll find editing formula in-cell cumbersome when the formula is big for the cell size. In those cases, use the formula bar.

Cell size can restrict how much your formula is visible when editing. You can increase the cell size via row and column heights, if you want to efit in-cell.