While I am writing a formula, I move the cursor to a
cell that I want to reference in the formula. Usually,
that gives me a relative reference (e.g. A10), and I
can use F4 to cycle through alternative forms ($A$10,
A$10,$A10).

But if the referenced cell is named, Excel uses the
name for the reference, and F4 does not change it.

How can I replace the name with a relative reference
without having to enter it manually?