Forum Discussion

Zoldyckillua's avatar
Zoldyckillua
Copper Contributor
Jan 20, 2022

Cell editing covers adjacent cell/s

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.

 

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?

excel
Formulas and Functions

2 Replies

  • NowshadAhmed's avatar
    NowshadAhmed
    Iron Contributor
    Jan 20, 2022
    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.
  • bosinander's avatar
    bosinander
    Iron Contributor
    Jan 20, 2022
    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.

Resources