Greyed formula that won't delete

New Contributor

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.

5 Replies
Hello, I cannot get my excel sheets to print with the grid lines. I the print gridlines box checked and not printing in draft print. Thanks, Richard
Windows 10 Home
Maybe you replied to my question instead of posting a new question? Do you have your cells highlighted white?

@Stumped650 

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.

S0993.png

@Stumped650

Just had this exact problem and came here to find a solution. But to no avail.

 

BUT then I noticed that one of the lines that my formula spilled in to was hidden. This made the formula greyed out. Once I unhid the line the formula became white and I was able to edit it. Why this is so I do not know. A feature or a bug?