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.

4 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?


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.