Dec 14 2021 09:58 AM
I have a formula in a cell: =+K3:K4/K4 The formula is grey and every time I hit delete, it comes back. I can overwrite it but not delete it. However this happened is purely accidental. I cannot find any help subjects on this. The cell is unlocked. I don't know what else to do.
Dec 14 2021 09:59 AM
Dec 14 2021 10:03 AM
Dec 14 2021 10:17 AM
If you have Office 2021 or Microsoft 365, the formula =+K3:K4/K4 will spill to two cells in a column.
You can only edit/delete this formula in the top cell. The formula will be grayed out if you select the bottom cell.