Forum Discussion
Greyed formula that won't delete
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 fi...
re-think your formula. I don't know why this "auto" function happens but I meant to to this:
=sum(a1:a3)*5
but instead typed this, which created the "greyed out" formula array(?):
=a1:a3*5
hope that helps