Forum Discussion
Excel keeps pasting the formula below and beside depending on whether I press enter or tab
Like I said in the title, when I try to calculate a formula by pressing enter or tab, excel applies the formula to the two rows below or beside the anchor cell. I don't know why this is happening, wh...
Your formula
=AT58:AT60/O7takes the range AT58:AT60 (3 cells) and returns result into the range of another 3 cells as one object (spill). Cells within that object are not editable, you may edit only formula in the first cell which will be applied to entire spill.
To make editable in each cell formula use =AT58/O7 and drag it down.
I assume you are on Excel 365 or Excel 2021 and later.